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
What format you want?
Use RW_DateToString() RW function.
in date IN_Date;in string IN_Format;
Format Syntax:-ddd = day of week as 3 lettersdddd = day of week in fullN = day of yearNN = day of year (padded)D = day of monthDD = day of month (padded)M = month of yearMM = month of year (padded)mmm = month of year as 3 lettersmmmm = month of year in fullYY = year of date (2 digits)YYYY = year of date (4 digits)
See here for more info:
http://blogs.msdn.com/developingfordynamicsgp/archive/2008/09/01/using-the-built-in-report-writer-functions.aspx
David Musgrave [MSFT]Escalation Engineer - Microsoft Dynamics GPMicrosoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)http://www.microsoft.com/Dynamics
mailto:David dot Musgrave at microsoft dot comhttp://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.
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
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.
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,
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.
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"
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
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 Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
