I have a date field when extracted using fetch XML query gives 01/15/2009 as a string. When I try to convert it to date using cdate it gives error.i tried using format, formatdatetime, from the configuration by setting the custom date format but it dint work.it gives #error.
If I try to convert the field.Value using cdate it works and converts to date, but then the value is not correct as the field in crm is saved with datetime behaviour as user local. So the date varies by +/- 1 day based on the region.
My question is like if I am able to retrieve the date as string m/dd/yyyy why it is not allowing me to use cdate to convert to date so then I can use format function to display accordingly.
•I want to display as 20-january-2020
•When used expression as =field!fieldname.value it shows 1/20/2020
And if used cdate(=field!fieldname.value) gives #error
•when used expression as=field!fieldnamevalue.value it shows 1/19/2020 ( +/-1 day)
Please let me know if any solution
Thanks
