Deep Dive: Date formating for formulas

Stevie LaFortuneStevie LaFortune Expensify Team Posts: 189 Expensify Team
edited February 2020 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/yyy
  • 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.