Return value of Text Field using Month Abbrveiations

[mckenneyj]

I have filed called "MonthPymtFor" Text 3 char
Contents: JAN FEB MAR APR... NOV
Need to return the month value for each record
i.e. 1 2 3 4 .... 11


Thanks,
John McKenney
Work Hard... Play Harder

 

[SgtJarrow]

Try:

Month(CDate([MonthPymtFor] & "/1/2004&quot)

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[Norris68]

MonthNumber = Month("1 " & [MonthPymtFor] & " 2000&quot

- builds a string e.g. "1 FEB 2000", then returns the month number (quick & dirty solution).