Forum Discussion
Solved
Using Date Range in SQL Statement to ODBC Data Source
What SQL statement should I use to return data from table F4111 in a date range of current date to previous year? Creation date column ILCRDJ in table F4111 holds a date entry that is a text string (...
Hi mhender,
Thank you for reaching out to Microsoft Fabric Community.
The error here is likely because ILCRDJ is stored as a text field not as a date datatype, so it cannot be compared directly with CURDATE().
Please convert the value to a date value first before comparing it, or use the same date format that is stored in the ILCRDJ for the comparison.
Thanks and regards,
Anjan Kumar Chippa
