Adding Column with Month & Year

[Dormie]

Hi, I was hoping for some help on the formula to add month and year.

I've used both in the past. Looking for the month and year in the same column.
Month: Month([date])


Year: Year([date])

Thank you.

[CJ_London]

something like

year([date]) *100+month([date]) for a numerical value

or

format([date],"yyyymm") for a text value

[Dormie]

Great Thank you Ajax,

Both worked, Not sure which one I'll use. I thought in a previous palying around database, I had a code that displayed Jan-2016, for months.

[CJ_London]

you can do that

format([date],"mmm-yyyy")

but you won't be able to sort it by months (Feb will come before Jan), you'll need an extra column to do that based on a numerical month.

Bty the way, youa re aware that date is a reserved word (it means today) so using it as a field name will cause problems at some point, so better to change it to something else