Forum Discussion

ScottErvin's avatar
ScottErvin
Qrew Cadet
7 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
RobIV's avatar
RobIV
Qrew Cadet
7 years ago
Try this slight variation:

(Formula Text Field)

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

Note: returns a text value, which I'm pretty sure you'll have to do to keep the leading '0'.

Thanks,

~Rob
  • ScottErvin's avatar
    ScottErvin
    Qrew Cadet
    7 years ago
    Outstanding!  That did it!  Thank you so much. 
  • DavidHawe's avatar
    DavidHawe
    Qrew Trainee
    7 years ago
    Yup, that is what I forgot.  Making it a text value