You’re offline. This is a read only version of the page.
340
dear,
i have to change the date format in report witer, plz help me, how can i change it.
*This post is locked for comments
Please help me how can i get current financial year format (2014-2015) and previous financial year format(2013-2014) in Navision Report?
Thanks Sagi, it worked great !
Hi Gaurav
Once the date field converted to string and placed on your page layout double click it to go to the properties.
Click on the Format expansion button (...) and create a new format ex: My_Date_Format.
In the Format String box enter X X X X X X X X (Must be in caps) and insert. These are the character holders.
Your date format should be fine.
Hope this helps
Using rw_datetostring am able to format the MMDDYYYY, but cannot split it.
Is there any function to add blank space in between string , for example to print "string" as "s t r i n g"
There is a function where you can convert the elements of the date to a string. I.e. you can get the first digit of the date on its own, the second digit on its own etc. If you use this function 8 times to break up your date into 8 different fields, you can put them on your report with the lines in between?
I think it is called RW Date String or something like that. (Don´t have access to GP at the moment to check).
Hope this points you in the right direction.
If we require to print on cheques where date is to be put as
| D | D | M | M | Y | Y | Y | Y |.
Then how do we do that,
Hi Muhammad, you can view my blog post on this very topic here: http://dynamicsgp.wordpress.com/2009/06/08/international-date-formats-in-report-writer/
Hope this helps.
Just use "DD-mmm-YYYY" as the format string in the RW function.
Please note the format of the date is controlled by the system's regional settings. Change away from US settings if you want something other than mm/dd/yyyy.
David
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David dot Musgrave at microsoft dot com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
Thank u for ur response
A report was created in report writer in which document date format is MM/dd/yyyy. The required format is
"dd-MMM-yyyy" i,e. 12-Apr-2010.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (