Forum Discussion

ScottErvin's avatar
ScottErvin
Qrew Cadet
6 years ago

How do I retain the leading 0 in a formula field coming from a date field?

I have an Invoice date field but i need to create a new field where the date comes out as YYYY-MM.  I started with Year([Invoice Date])&"-"&Month([Invoice Date]) but the Month does not retain the lea...
Formulas and functions
DavidHawe's avatar
DavidHawe
Qrew Trainee
6 years ago
Try this which is untested by me

If(
Month([Invoice Date])<10,
Year([Invoice Date])&"-0"&Month([Invoice Date]),
Year([Invoice Date])&"-"&Month([Invoice Date])
)