Forum Discussion
DavidHawe
7 years agoQrew Trainee
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])
)
If(
Month([Invoice Date])<10,
Year([Invoice Date])&"-0"&Month([Invoice Date]),
Year([Invoice Date])&"-"&Month([Invoice Date])
)