Are you receiving SNAP/EBT benefits? The Expensify.org/SNAP-VAX campaign is live and accepting new members. Learn more about receiving $50 for submitting a SNAP receipt and $50 for getting your COVID-19 vaccine here and join today!

Deep Dive: Date formatting for formulas

Stevie LaFortune
Stevie LaFortune Expensify Team Posts: 231 Expensify Team
edited April 2021 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: