AnneC
Scholar

List of Date Formats

Jump to solution

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?

0 Kudos
Reply
3 Replies
Garrett
Contributor

Re: List of Date Formats

Jump to solution
0 Kudos
Reply
Garrett
Contributor

Re: List of Date Formats

Jump to solution

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

Garrett_0-1655398837172.png

 

0 Kudos
Reply
AnneC
Scholar

Re: List of Date Formats

Jump to solution
Thank you so much!!!! This wasn't in any of the searches I tried, maybe I had the forum filtered or something.
0 Kudos
Reply