10 Replies Latest reply: May 12, 2015 5:37 AM by Harrison Chisonga RSS

    Aligning Date formats

    Harrison Chisonga

      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