The date fields in our database are in nvarchar (255) format.
So 1/1/2020 is 43831
How can i convert the field SHIP_DATE from nvarchar format to a Date field?
I've been trying to do a custom column in the elasti-cube and tried using CreateDate, but no luck yet...
In SQL i can do the following:
|select convert(date,cast ((dbo.plog.SHIP_DATE+ 19000000 as nvarchar(10)))|
Please sign in to leave a comment.