Skip to main content
Nintex Community Menu Bar
Solved

List of Date Formats

  • June 16, 2022
  • 3 replies
  • 46 views

Forum|alt.badge.img+6

I am trying to find a comprehensive list of formats for the FormatDate function, but can't find a full list.

 

For example, format using "d" returns the day of the week number (extremely useful) and "ddd" returns day short name, so today is 4 or Thu, respectively. The help topic doesn't show either of these, so I know the list is not complete.

 

I found that to the week number, use "w". An example of why I'd like that is if I can figure out if it's an odd week or even, I can calculate if it's pay week or not, and send reminders to enter time on the appropriate day prior to payday.

 

So short of my trying the entire alphabet, is there a full list somewhere?

Best answer by Garrett

Hi @AnneC 

 

This is from Nintex Help - Custom Date Formats Option and Examples 

https://help.nintex.com/en-US/nwc/Content/Designer/Functions/formatDate.htm

Expand to view the Local format options or the Custom date format options

 

3 replies

Garrett
Forum|alt.badge.img+16
  • Scout
  • June 16, 2022

Garrett
Forum|alt.badge.img+16
  • Scout
  • Answer
  • June 16, 2022

Hi @AnneC 

 

This is from Nintex Help - Custom Date Formats Option and Examples 

https://help.nintex.com/en-US/nwc/Content/Designer/Functions/formatDate.htm

Expand to view the Local format options or the Custom date format options

 


Forum|alt.badge.img+6
  • Author
  • June 16, 2022
Thank you so much!!!! This wasn't in any of the searches I tried, maybe I had the forum filtered or something.