Formatting a date.

[Alexey]

Hi I am trying to format the current date into mmm-yy format

i have been trying Format((Today),"mmm-yy"), but clearly that is wrong. can
anyone help please?

tks

Z

 

[Allen Browne]

Try:
=Format(Date(),"mmm-yy")

Of course, the output of Format() is text, so you will get text sorting
(April before January), and can't match it against dates.

 

[Alexey]

Thanks Allen