topic QVC - Timestamp# and Date in QlikView https://community.qlik.com/t5/QlikView/QVC-Timestamp-and-Date/m-p/672086#M1241620 <HTML><HEAD></HEAD><BODY><P>I've been experimenting with the Qlikview components extension, in particular for the calendar feature.&nbsp; 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.</P><P></P><P>I have a date field which has date in two formats 'YYYY-MM-DD hh:mm:ss.fff' and 'm/d/yyyy'.</P><P></P><P>When calling the following CalendarFromField the only assoication that is created is for the dates 'm/d/yyyy'.&nbsp; I'd like for the association to happen on both date formats. How would you accomplish this using QVC?</P><P></P><P>SET Qvc.Loader.v.DatabaseDatetimeMask = 'YYYY-MM-DD hh:mm:ss.fff';</P><P>CALL Qvc.CalendarFromField('InpatientAdmissionOn', Timestamp#)</P></BODY></HTML> Mon, 26 Jan 2026 16:26:21 GMT NickHoff 2026-01-26T16:26:21Z QVC - Timestamp# and Date https://community.qlik.com/t5/QlikView/QVC-Timestamp-and-Date/m-p/672086#M1241620 <HTML><HEAD></HEAD><BODY><P>I've been experimenting with the Qlikview components extension, in particular for the calendar feature.&nbsp; 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.</P><P></P><P>I have a date field which has date in two formats 'YYYY-MM-DD hh:mm:ss.fff' and 'm/d/yyyy'.</P><P></P><P>When calling the following CalendarFromField the only assoication that is created is for the dates 'm/d/yyyy'.&nbsp; I'd like for the association to happen on both date formats. How would you accomplish this using QVC?</P><P></P><P>SET Qvc.Loader.v.DatabaseDatetimeMask = 'YYYY-MM-DD hh:mm:ss.fff';</P><P>CALL Qvc.CalendarFromField('InpatientAdmissionOn', Timestamp#)</P></BODY></HTML> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/QVC-Timestamp-and-Date/m-p/672086#M1241620 NickHoff 2026-01-26T16:26:21Z