Formatting a date.

  • Thread starter Thread starter Alexey
  • Start date Start date
A

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
 
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.
 
Back
Top