Forum Discussion
convert date to integer
I have a dataset for a Date Dim (Integer date, full date datetype & all possible hierarcies ). I do a join to another datecolumn in a transtional dataset . Both are of datatype date same format (mm/d...
this worked. i did the same thing, but did not include the " " around my format, so it did not takerecognize it. I tried to use 0000, but it gave the generic 4681 that it always gives
=FORMAT ([Date], "YYYYMMDD" ) does work to convert DateTime data format to text.
Thanks for correcting my error!
The " " is used to name the column when create a calendar table.
As you create column it's name without " ". Am pleased to hear the you managed to resolve your issue with changetype. Please mark the issue as resolved. Thanks :-)