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#)