Month Number

[Anil_Babu_Samineni]

Hi,

I have one field

LOAD * INLINE [

    MonthFrench

    janvier

    février

    mars

    avril

    mai

    juin

    juillet

    août

    septembre

    octobre

    novembre

    décembre

];

So, here i want to show number 1,2,3,4,....12 in list box. How?

If i use this

if(MonthFrench='janvier',1,

//        if(MonthFrench='février',2,

//              if(MonthFrench='mars',3,

//                    if(MonthFrench='avril',4,

//                          if(MonthFrench='mai',5,

//                                if(MonthFrench='juin',6,

//                                           if(MonthFrench='juillet',7,

//                                                           if(MonthFrench='août',8,

//                                                                 if(MonthFrench='septembre',9,

//                                                                      if(MonthFrench='octobre',10,

//                                                                            if(MonthFrench='novembre',11,

//                                                                                 if(MonthFrench='décembre',12))))))))))))

It will come, But i want to see only these values instead of Name months

[Anil_Babu_Samineni]

Sunny, Thanks i am fetching data from Database.

I have one field which is Date

Now i change to month(Date)

Here, I need to apply that How to do that?

[sunny_talwar]

Try using mindaugasbacius‌'s logic here:

Num(Month(Date)) as MonthFrench

[Anil_Babu_Samineni]

Ok, Majorly i am looking Inline. In future, i want to know. Any way,

Thanks Miindaugas & Sunny