Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I got a problem with the command 'Month' it returns a name and I need integer.
can anybody help me?.
best regards.
Num(Month(Yourfield))
hope this helps
regards
Marco
you can use
NUM(MONTH(FIELD))
or
Date(FIELD,'MM') -- Assuming FIELD format is in 01/01/2014
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.
For the Month you have some functions:
Month(Date) for the name of month
num(Month(Date) for the number of month
thanks a lot Marco.
you're welcome
please close this thread if you don't have further questions
thanks
regards
Marco