Notifications
Announcements
No record found.
Hi
what is the difference at DataItem in report between
FORMAT("Purchase Header"."Order Date") and "Purchase Header"."Order Date"
Thanks
*This post is locked for comments
Format function Formats a value into a string
Hi,
FORMAT("Purchase Header"."Order Date") will fetch and format your Order Date value to a string. After using format you can assign this value i.e. FORMAT("Purchase Header"."Order Date") to a variable of text datatype.
"Purchase Header"."Order Date" expression is just used to fetch Oder date from Purchase header.
Hi Jsshivalik,
FORMAT("Purchase Header"."Order Date") returns a string whereas "Purchase Header"."Order Date" is a date.
Take a look at Format function for more information: msdn.microsoft.com/.../dd301367.aspx
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
