0 Replies Latest reply: Jul 14, 2014 3:14 PM by Nick Hoff RSS

    QVC - Timestamp# and Date

    Nick Hoff

      I've been experimenting with the Qlikview components extension, in particular for the calendar feature.  I know how to solve this problem without QVC both in Qlikview and modifying the original query, but I'm looking for a solution which utilizes QVC.

       

      I have a date field which has date in two formats 'YYYY-MM-DD hh:mm:ss.fff' and 'm/d/yyyy'.

       

      When calling the following CalendarFromField the only assoication that is created is for the dates 'm/d/yyyy'.  I'd like for the association to happen on both date formats. How would you accomplish this using QVC?

       

      SET Qvc.Loader.v.DatabaseDatetimeMask = 'YYYY-MM-DD hh:mm:ss.fff';

      CALL Qvc.CalendarFromField('InpatientAdmissionOn', Timestamp#)