Month name to numbers

[#1]

Hi,

How to get month name into numeric representaion.

like jan as 1, feb as 2 and ....

i already hav a list box which has like jan,feb. i need in form of numerics (1,2,3,..)

thanks.

[Anonymous · Accepted solution]

Use this:

Num(Month(Date_Field))

[SunilChauhan]

if month is Jan,Feb,Mar .....

andfiled is Month

then write

Num(Month)  in list

or use in script as

Num(Month) as Monthnum

or else use

inline wizard like below

load * inline

Month,MonthNum

Jan,1

Feb,2

Mar,3

apr,4

;

;

;

];

or

using if(Month='Jan',1,if(Month='Feb',2,if(Month='Mar,3.........))))))))))))

thanks

Sunil Chauhan

[#4]

thanks bala , i got it with your solution