Forum Discussion
Using mutltiple dates in a table
Hi, I have a question using dates in a table. I have a dataset consisting of the following columns: name, date, score The dates range is different per dataset, but it's done per day, so eac...
Thanks for your reply Greg_Deckler!
I'll check it out tomorrow on my working computer.
One other question though, How do I get those date columns? They don't seem to work.
Like, can I get columns starting on the first of the month for example?
Thanks again.
Kind regards,
Henricus
Henricus You can use something like DATEVALUE("Jan 2022")
Greg_Deckler ahh, like just a new measurement?
Thanks!Henricus Well, if your current data just has the 3 letter month name, create a new calculated column like this:
Date2 = DATEVALUE([Date] & " 2022")