Aligning Date formats

[chiso_chiso]

Gurus,

I have a date in my fact table and a date qvd which I want to use for my calendar in the model.

The date in my fact table is DateOfSale (Date format numeric i.e. 42087.327071759). The DateID field (YYYYMMDD) in the qvd is one I want to use but there is another field called DateStamp (DD/MM/YYYY hh:mm:ss).

Kindly help to align the two so that I can populate the qvd using the DateOfSale dates.

Regards, Harrison

[chiso_chiso · Accepted solution]

For some reason I have,

In Fact Load: Date(Floor(DateOfSale)) As SaleDate

In Calendar Load: Date(Date#(DateID,'YYYYMMDD')) as SaleDate

And it has worked..

Regards