Hello guys, i need your help about thisโฆ
Iam add a virtual column to convert date coloun to textโฆ with this formulaโฆitโs work
INDEX(
LIST(
โJANUARIโ, โFEBRUARIโ, โMARETโ, โAPRILโ, โMEIโ, โJUNIโ,
โJULIโ, โAGUSTUSโ, โSEPTEMBERโ, โOKTOBERโ, โNOVEMBERโ, โDESEMBERโ
),
MONTH([Date])
)
But, and then i want to sort them with making a new virtual column againโฆ Like thisโฆ
IFS([Month] = โJANUARIโ, โ1. JANUARIโ,[Month] =โFEBRUARIโ,โ2. FEBRUARIโ,
[Month] =โMARETโ,โ3. MARETโ,
[Month] =" APRIL",โ4. APRILโ,
[Month] =โMEIโ,โ5. MEIโ,
[Month] =โJUNIโ,โ6. JUNIโ,
[Month] =โJULIโ,โ7. JULIโ,
[Month] =โAGUSTUSโ,โ8. AGUSTUSโ,
[Month] =โSEPTEMBERโ,โ9. SEPTEMBERโ,
[Month] =โOKTOBERโ,โ10. OKTOBERโ,
[Month] =โNOVEMBERโ,โ11. NOVEMBERโ,
true, โ12. DESEMBERโ)
Its oke but, i have a summary problem with thisโฆwhen the value is at April, itโs not work like i wantโฆ the value not 4. Apil but a shown like thisโฆ
Sun Apr 04 2021 00:00:00 GMT+0700 (Waktu Indonesia Barat)โฆ
Can somebody help me to complet this bugโฆor my formula is wrong.
Please correctly is
Hi, @taufiq_qurohman
I think itโs because this is the only line with different double quotation marks.
[Month] =" APRIL",โ4. APRILโ,
Like this?
[Month] =โAPRILโ,โ4. APRILโ,
Good catch
Hi, @taufiq_qurohman
Sorry.
I think you need to change the double quotation marks, but I tried it myself and got the same result.
Could be a bug.
@Steve
Who should I mension in this case?
Even in my environment, the April result gets a Datetime return value, not a text value.
I think itโs a problem that the timestamp is the return value in the following format, but maybe itโs the correct syntax in AppSheet?
โ(Number). (Month Name)โ
ex)
โ11. NOVEMBERโ
Out of curiosity, what is going to happen if we pass
TEXT(โ4. APRILโ)
instead of
โ4. APRILโ
Because April
and November
are month names in English, AppSheet recognizes "4. April"
and "11. November"
as Date values (the 4th of April and 11th of November, respectively). As you discovered, CONCATENATE() is a workaround for this.
Thank you @tsuji_koichi
@taufiq_qurohman
Using CONCATENATE seems to be a workaround.
However, currently the following format may be judged as Date or Datetime type.
โ11. NOVEMBERโ
โ4. APRILโ.
It is recommended to develop in a different text format if possible.
ex)
โ11_NOVEMBERโ
FYI
@Steve
So good ideas i have ready to use this formula and its work perfeclyโฆthanks for help
This way can fixed a bug while waiting completion from case
Thanks for the follow up @Steve
Itโs nice to know another smart feature of AppSheet.
Is there a help page or something that collects Syntax that work a little differently like this?
There is not.
Yes sir,
Iโll enjoy the AppSheet Adventure Tour trip, where the mystery is still deep.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |