Deep Dive: Date formatting for formulas
Stevie LaFortune
Expensify Team, Expensify Student Ambassador Posts: 241 Expensify Team
Formating the date to export in the way that you want really isn't that tricky when using the suggestions below.
Most Common Date Formulas
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
Have a question or want to know more? Start a discussion here!
Tagged:
