Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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
I think you don't need to use an expression to calculate your date with the "20-january-2020" format. You can use the following steps: 1- Right click + textbox properties
2- Select the format you want
Then go to the custom category to customize your selected format:
Thanks for the reply. I had tried this first thing.but it dint work for me.
If I use that as well the date I get is 1/20/2020 not according to format I set
Cdate did not work because personalised setting for date format was different so it was not able to interprete the date. Changed report language to user! language
Working fine now.thanks
Business Applications communities