Forum Discussion
Calendar Table returning error: The expression specified in the query is not a valid expression
Try using the CALENDARAUTO() function, that will automatically scan all the date columns in the model and should return a valid table even in the presence of blanks.
I spoke too soon, it returned the error "The start date in Calendar function can not be later than the end date." again 😪
Super UserYou may want to check the data in the 'Deskside QA' table. You can use the MIN and MAX functions in a different way too, to get the lesser of two dates.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
I am doing that and the moment when I add anything to the list with a date later than September 28, 2023, that error seems to appear (The start date in Calendar function can not be later than the end date.) even if I enter it manually step by step in the list. (Avoiding copy+paste)
Attached is an export of the data I am trying to put in the list
Google Drive Link to DS_Asset QA csv
The expected outcome is a Calendar table with a list of dates.I want to use this table to create a splice including the Previous Quarter, Last Year, Previous Month, etx
- lbendlin
Can't seem to reproduce the issue?
It's possible that it's a limitation in sharepoint as opposed to the plain export through excel, I obviously can't share the sharepoint data directly but that's the export so I'm not sure what else to say, I'm trying to build a new list as we speak