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.