Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date Hierarchy Needed

Hi,   I need to create a Calculated Column using a date column by multiple & statements to create a unique key in the Fact Table. However I do not need the time portion of the date table. The probl...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You may try

    New Column = DATEVALUE([DATE])
    New Column = DATE(YEAR([DATE]),MONTH([DATE]),DAY([DATE]))

     

    If your DATE column is Date/Time type, the new column will be Date/Time as well.

     

    So that you could follow Samarth_18 's suggestion to manually change the new column 's type to Date. Or go to Column Tools --> Change Data type:

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

You may try

New Column = DATEVALUE([DATE])
New Column = DATE(YEAR([DATE]),MONTH([DATE]),DAY([DATE]))

 

If your DATE column is Date/Time type, the new column will be Date/Time as well.

 

So that you could follow Samarth_18 's suggestion to manually change the new column 's type to Date. Or go to Column Tools --> Change Data type:

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.