Forum Discussion
Grouping Data
Hi,
In the Query Editor, seperate that column into 2 - one with Date and another with time. Now build the Calender Table.
Ashish_Mathur Thank you for the feedback. I've followed your steps of trying to create a calendar table but when entering my formula to create the data I'm getting an error" Cannot convert value '2023-11-13 (11:56PM)' of type Text to type Date." Any ideas? I did try to transform my data from Text to Date but it just produces another error, "DataFormat.Error: We couldn't parse the input provided as a Date value. Details: 2022-10-19 (12:21 AM).
Hi,
In the Query Editor, seperate that column into 2 - one with Date and another with time. Now build the Calender Table.
That totally worked and I was able to create my calendar table and customize with the help of this video from Haven's Consulting https://www.youtube.com/watch?v=Cxdk_atKFBM