Share
ReportHi
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
You’re offline. This is a read only version of the page.
3,027
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
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
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.
Format function Formats a value into a string
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (