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.
User | Count |
---|---|
25 | |
25 | |
25 | |
23 | |
16 |