How to format a date on a report.

My user is asking for a date to be formatted as YYYY-MMMM or just MMMM.  For the life of me I can’t find a way to change the format of a date on a report without changing the system default format.

Is this possible?

Or do I need to recreate the Sales by Item Detail report as a saved search?

Sorry I’m super new to NetSuite.

Rookie Asked on May 31, 2022 in How To's.
Add Comment
1 Answer(s)

The user can change their personal date format preferences at Home>Set Preferences, scroll down to Formatting & select the Date Format YYYY-MM-DD & the Long Date Format YYYY Month DD.  These are “Personal” preferences and can be different for each person. The users can selected any of the Set Preferences values as they like.

You can change yours just to see the results before letting the user know.

Preferences Path Screen Shot


Sample Sales by Item Screen Shot of date format

Beginner Answered on July 8, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor