Forum Discussion
RobIV
7 years agoQrew Cadet
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
(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
- ScottErvin7 years agoQrew CadetOutstanding! That did it! Thank you so much.
- DavidHawe7 years agoQrew TraineeYup, that is what I forgot. Making it a text value