This content has been marked as final. Show 4 replies
Hi ,1 person found this helpful
You can try "timestampadd/timestampadd" from calender functions , with casting (cast function) the two date columns (whose data types are varchar) .
thanks for reply
Cast(created date as date time) but got the error in OBIEE.
Cast as date will not work in sqlserver.
any other suggestion.
Try using CONVERT (ex : convert(data_type(length),expression,style)) instead of CAST , in SQL server .
In your cube have you set the type to 'Date' for this attribute? If not, try it and let me know if this still imports as varchar.
Hope this helps.