5 Replies Latest reply: Jan 13, 2014 5:34 PM by Srikanth P RSS

    Is there a standardized date format I should implement on load?

    Darrin Pilkington

      I know QlikView does a great job of recognizing dates but on my QVD creation, should I transform each date so it is always recognized in further scripting without question.

       

      I ask because I ran into an issue with an intervalmatch() solution I was trying and it did not seem to recognize the date properly.

       

      So I ask, should we always transform the date, datetime and time fields in the load statement?

       

      If so, what is recommended to always work?

       

      Thanks