I got a problem with the command 'month'

[#1]

I got a problem with the command 'Month' it returns a name and I need integer.

can anybody help me?.

best regards.

[MarcoWedel]

Num(Month(Yourfield))

hope this helps

regards

Marco

[phaneendra_kunc]

you can use

NUM(MONTH(FIELD))

or

Date(FIELD,'MM') -- Assuming FIELD format is in 01/01/2014

[jagan]

Hi,

Month(Yourfield) * 1

also returns numeric month, since month is Dual type.  By default it will return string month, if you require as number then you have to convert by using Num()  or Date(FieldName, 'M') or by multiplying with 1.

Hope this helps you.

Regards,

Jagan.

[ecolomer]

For the Month you have some functions:

Month(Date) for the name of month

num(Month(Date) for the number of month

[#6]

thanks a lot Marco.

[MarcoWedel]

you're welcome

please close this thread if you don't have further questions

thanks

regards

Marco