News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP forum RW_DatetoString functi...

Microsoft Dynamics GP forum

Answered

RW_DatetoString function does not appear to be working

(0) Share

Report

Report

Posted on by Heather Roggeveen

9,142

Hi

After finding different blogs on displaying dates in any format, I have attempted to use the RW_DatetoString function in the RM Statement on Blank Paper report in Dynamics GP 2018 with no luck.

This is the calculation (The FUNCTION SCRIPT ( is there, my window doesn't open up big enough to show it).

And my result is literally mmddyyyy:

I have tried with the date fields RM Statement Header Temp - Date, RM Statement Transaction Temp - Document Date, RM Open File - Document Date. All with the same result.

What am I doing wrong?

Cheers

Heather

Categories:

Reporting and BI

All responses Img

All responses (2)

Answers Img

Answers (1)

Heather Roggeveen 9,142 on at

Like (0)

Report

RE: RW_DatetoString function does not appear to be working

Hi

I tried your suggestion with the same result. So I thought, maybe I will just try DDMMYYYY (i.e. use capitals) - turns out, the case matters and that has done what I needed it to do.

Thanks for the suggestion - that, combined with a fresh head made me try something different!

Cheers

Heather
Verified answer

Almas Mahfooz 10,996 User Group Leader on at

Like (0)

Report

RE: RW_DatetoString function does not appear to be working

Try like

DD-mmmm-YYYY

or

mmmm-DD-YYYY

ddd                  = day of week as 3 letters

dddd                = day of week in full

N                      = day of year

NN                    = day of year (padded)

D                      = day of month

DD                   = day of month (padded)

M                     = month of year

MM                   = month of year (padded)

mmm                = month of year as 3 letters

mmmm             = month of year in full

YY                    = year of date (2 digits)

YYYY               = year of date (4 digits)

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2

Martin Dráb 228,493 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans