web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / RW_SysDate
Microsoft Dynamics GP (Archived)

RW_SysDate

(0) ShareShare
ReportReport
Posted on by iruser2 2,048

HI folks

I want to format the sys date field that is on the packing slip and picking ticket to be month in three letters.

I have the RW_Datetostring function that will do the formatting for me, but I need the system date

I have found the RW_SysDate function but am at a loss as to its parameters.

looking at:

http://msdynamicstips.com/2014/06/10/rw-functions-global-scripts/

and

http://www.sanjaykumar.us/index.php/dynamics-gp-report-writer-global-functions-part-3-date-time-functions/

what the heck does this mean:

Parameters:

in integer IN_mode. non-zero = SQL Server Date

can someone give me an example of getting the sys date function to work so I can run it through the formatter function.

thanks!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    DinB Profile Picture
    DinB 3,951 on at

    Try following:

    Create first Calculated Field named "MySysDate"
    Result Type: Date
    Expression Type: Calculated
    Expression: FUNCTION_SCRIPT(RW_SysDate 0)

    Parameter: 0 means system date in your PC
    non zero means system date in SQL Server machine

    Create Second Calculated Field named "MySysDateStr"
    Result Type: String
    Expresson Type: Calculated
    Expression: FUNCTION_SCRIPT(RW_DateToString MySysDate "mmm, DD YYYY")

    Add the "MySysDateStr" field to the report.

  • iruser2 Profile Picture
    iruser2 2,048 on at

    perfect - the placement of that 0 makes a huge difference I had it outside the brackets.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans