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!

  • ArneHoefkens's avatar
    ArneHoefkens
    Advocate I
    5 years ago

    You could wrap a VALUE function around it
    = VALUE(FORMAT ([Date], "YYYYMMDD" ) )

  • gselvag's avatar
    gselvag
    Helper I
    7 years ago

    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 :-)