Forum Discussion

mmoizk's avatar
mmoizk
Helper III
10 years ago

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...
Need Help
gselvag's avatar
gselvag
Helper I
7 years ago

I have created a DateKey in my calendar datatable that work.

Try use following FORMAT ( [Date]; "YYYYMMDD" ) as DateKey column in your table. The value has to be converted to Whole Number by change column datatype.

JulianPayne_i4's avatar
JulianPayne_i4
Frequent Visitor
7 years ago

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!