Date expression help needed

[Tiger1]

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?

[Suvrutt_Gurjar]

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”)

help.appsheet.com

TEXT()

Format as text

[Tiger1]

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:

[Steve]

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.

[Tiger1]

Ah, ok. Question? Can i take any of that date apart and then get the month (maybe the month number)?

[Steve]

Sure:

NUMBER(MID([LAST SEEN TIME], 6, 2))

See also:

help.appsheet.com

MID()

Characters from text

help.appsheet.com

NUMBER()

Number from any value

[Tiger1]

It gives me this error:

nm. Works now. Thanks

[Tiger1]

Can I make the numbers - be the month name?

01 - January
etc…

[Steve]

Yep:

INDEX(
  LIST(
    "01 - January",
    "02 - February",
    ...,
    "12 - December"
  ),
  NUMBER(MID([LAST SEEN TIME], 6, 2))
)

[Tiger1]

It gives me this? I don’t want the time and that format. I just wanted the month. Did I write something wrong?

[Steve]

Please post a screenshot of the configuration for the column.

[Tiger1 · Accepted 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.

[Steve]

Bingo! Well done!