The date format DD-MMM-YYYY isn't accepted, and raises an error 'Conversion failed when converting date and/or time from character string'.
A date in the format DD-MM-YYYY is accepted.
The date format DD-MMM-YYYY worked previously, and has stopped working in a recent update (I think in the last 2-3 months)
Are you aware of this? Is it by design?
EXAMPLE
Doesn't work
select top 50 * from contract where createdon > '01-JAN-2025'
Does work
select top 50 * from contract where createdon > '01-01-2025'
Version
Microsoft Dataverse - 9.2.25032.214
SQL 4 CDS - 9.6.0.0
Mar 04 2025 15:00:01
Copyright © 2020 - 2024 Mark Carrington
The date format DD-MMM-YYYY isn't accepted, and raises an error 'Conversion failed when converting date and/or time from character string'.
A date in the format DD-MM-YYYY is accepted.
The date format DD-MMM-YYYY worked previously, and has stopped working in a recent update (I think in the last 2-3 months)
Are you aware of this? Is it by design?
EXAMPLE
Doesn't work
select top 50 * from contract where createdon > '01-JAN-2025'Does work
select top 50 * from contract where createdon > '01-01-2025'Version
Microsoft Dataverse - 9.2.25032.214
SQL 4 CDS - 9.6.0.0
Mar 04 2025 15:00:01
Copyright © 2020 - 2024 Mark Carrington