date field

D

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
 
V

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)
 
D

David

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