Date expression help needed

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 Solved
0 12 528
1 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.

View solution in original post

12 REPLIES 12
Top Labels in this Space