How to put Month ID ?

Report Inappropriate Content · ‎2016-09-21

Hi All,

I have a date field, from that i can derive Month Name. How to put MonthID ?

Please help.

fvelascog72 · ‎2016-09-21

Hi,

Maybe you can try:

Num(Month(Date))

Cheers.

Anil_Babu_Samineni · ‎2016-09-21

You can use simply

Month(DateField) as Month

And

MonthID

Num(Month(DateField)) as MonthID

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

QlikView App Dev