web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • iruser2 Profile Picture
    iruser2 2,048 on at
    RE: RW_SysDate

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

  • Verified answer
    DinB Profile Picture
    DinB 3,914 on at
    RE: RW_SysDate

    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.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans