Solved

List of Date Formats


Badge +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?

icon

Best answer by Garrett 16 June 2022, 18:53

View original

3 replies

Userlevel 6
Badge +16

Hi @AnneC 


 


Try this link https://community.nintex.com/t5/Community-blogs/Date-and-Time-Format-Strings-Quick-Reference-Guide/ba-p/81050


 



 


Hopes that helps

Userlevel 6
Badge +16

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



 

Badge +6
Thank you so much!!!! This wasn't in any of the searches I tried, maybe I had the forum filtered or something.

Reply