Deep Dive: Date formatting for formulas

Stevie LaFortune
Stevie LaFortune Expensify Team Posts: 211 Expensify Team
edited April 1 in Deep Dive Docs
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
Have a question or want to know more? Start a discussion here!
Tagged:
Sign In or Register to comment.