Deep Dive: Date formatting for formulas

Stevie LaFortune

Formating the date to export in the way that you want really isn't that tricky when using the suggestions below.

IMPORTANT 

Date formulas are case sensitive! - That is "mm" is not the same as "MM"

The default date export format is {report:startdate:yyyy-MM-dd}.  To change the date, format simply update the formula after the colon such as {expense:created:MMM, yyyy} 

Most Common Date Formulas

• 5/23/2019          M/dd/yyyy
• May 23, 2019     MMMM dd, yyyy
• 23 May 2019      dd MMM yyyy
• 2019/05/23         yyyy/MM/dd
• 23 May 2019      dd MMM yyyy
• 2019/05/23         yyyy/MM/dd
• May, 2019           MMMM, yyyy
• 19/05/23             yy/MM/dd
• 23/05/19             dd/MM/yy
• 2019                    yyyy

Related articles

• Deep Dive: Understanding custom export templates and formulas

• Deep Dive: Expense level formula

• Deep Dive: Report level formula

• Deep Dive: User level formula

• Deep Dive: GL Code formula

• Deep Dive: Default report title best practices, which formula is eligible, formula that update based on report information (submission date, date of last expense)

Have a question or want to know more? Start a discussion here!