I need to be able to take a date in this format:
and make a view to list the months (group the months together)
I have this to take the month number out of the raw data:
Then i use this to create the list (by month in order):
But i keep getting “invalid date”
So somewhere I am missing the month from the original raw data?
Solved! Go to Solution.
I had to make the Type = Text.
Also on [Last Seen Time] the Type is also “Text”
nm Steve - i got it. Thank you very much for your help as usual.
I believe you could use the TEXT() expressions to get the month straightaway from the datetime column like below
TEXT(DATE([LAST SEEN TIME]), “MMMM”)
or even
TEXT([LAST SEEN TIME], “MMMM”)
I tried this - it does not work. It gives me this:
No month is showing. Also, this number - “3277” is raw data that should be separated into months- it seems to still be grouping it all together. This leads me to believe it is NOT understanding the month expression.
To further show you what i want - i have this working for another app:
However - the [Date] - column is in a different format. I believe this is why I am unable to do it here.
Date format that works:
Date format I am having trouble with:
I have it now putting everything in this month, but i want it to separate into the month it is:
As you can see, a lot of these are NOT September and yet are grouping under September:
AppSheet doesn’t recognize the date/time format you’re using (YYYY-MM-DD HH:MM ZZZ).b AppSheet requires the stored dates be in MM/DD/YYYY format and times be either HH:MM or HH:MM:SS with no timezone specification.
Ah, ok. Question? Can i take any of that date apart and then get the month (maybe the month number)?
Sure:
NUMBER(MID([LAST SEEN TIME], 6, 2))
See also:
It gives me this error:
nm. Works now. Thanks
Can I make the numbers - be the month name?
01 - January
etc…
Yep:
INDEX(
LIST(
"01 - January",
"02 - February",
...,
"12 - December"
),
NUMBER(MID([LAST SEEN TIME], 6, 2))
)
It gives me this? I don’t want the time and that format. I just wanted the month. Did I write something wrong?
Please post a screenshot of the configuration for the column.
I had to make the Type = Text.
Also on [Last Seen Time] the Type is also “Text”
nm Steve - i got it. Thank you very much for your help as usual.
Bingo! Well done!
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |