RW_DateToString Function

[Baker@discussions.microsoft.com Lori Baker]

Hi,
I need to modify the A/P check's date to read YYYYMMDD instead of the
standard US format. I understand that I need to use the combination of the
RW_DateToString and RW_MakeDate functions but am unable to make these work
together. Can someone give me some assistance?

Thanks,

Lori

[Leslie Vail]

You can do it with just the RW_DateToString function. Your calculated
field will look like this:

RW_DateToString( PM_Payment_WORK.Document_Date "YYYYMMDD" )

For the date of 06/01/2017 this format would look like this:
20170601. Is this what you wanted? Did you want any dashes or
anything?

Please let me know if you need any more help, Report Writer is one of
my areas of expertise. Love it or hate it, Report Writer is here to
stay.

Leslie

[Lori Baker]

That is perfect!!!!