Skip to Content
0
Jan 11, 2019 at 04:50 PM

Convert Date to Month number : using todate

81 Views Last edit Jan 11, 2019 at 05:42 PM 2 rev

Hello All,

I need to convert a date " mm-dd-yyyy' to month number like '43203'

I am trying to use daysinbetween(firstdate, lastdate)

defining firstdate = ToDate("01/01/1900";"mm/dd/yyyy") and lastdate will be picked from my table

when i create a Dimension in IDT i am getting missing expression for todate . I do not see what wrong i did

Also , ToDate("01/01/1900";"mm/dd/yyyy") asks me to refer a table and i refered some table since.

I need help on where i am going wrong. Please see screenshot.

Thanks everyone.

Attachments

query2.png (32.9 kB)