date field

[David]

Hi

I have a report that I need a field to display the current month as a
letter. Is this possible?

January=A
Frebruary=B
March=C
April=D
May=E
June=F
July=G
August=H
September=J
October=K
November=L
December=M


Thanks in advance,
David

 

[Van T. Dinh]

Choose(Month(Date()), "A", "B", "C", "D", "E", "F", "G", "H", "J", "K", "L",
"M")

should do.

What happens to "I"?

If you use "A" to "L", you can also use:

Chr(Asc("A") + Month(Date()) - 1)

 

[David]

Thanks Van for your help. "I" does not get used so your example worked
absolutely fine.