topic Re: Calendar in QlikView https://community.qlik.com/t5/QlikView/Calendar/m-p/1158285#M377662 <HTML><HEAD></HEAD><BODY><P>Date# seems to have done the trick</P></BODY></HTML> Thu, 14 Jul 2016 13:46:35 GMT kevbrown 2016-07-14T13:46:35Z Calendar https://community.qlik.com/t5/QlikView/Calendar/m-p/1158283#M377660 <HTML><HEAD></HEAD><BODY><P>I'm creating an app that is bring in around 20 tables all with different date fields, for example, referral date, admission date, contact date, closed date, bed day date.&nbsp; Some of these are just dates some are date time fields.&nbsp; How best should i create a master calendar with these fields? My current calendar doesn't seem to want to work due to the date-time fields</P></BODY></HTML> Thu, 14 Jul 2016 13:28:20 GMT https://community.qlik.com/t5/QlikView/Calendar/m-p/1158283#M377660 kevbrown 2016-07-14T13:28:20Z Re: Calendar https://community.qlik.com/t5/QlikView/Calendar/m-p/1158284#M377661 <HTML><HEAD></HEAD><BODY><P>You could separate dates and times per:</P><P></P><P>date(floor([date-time])) as Date,</P><P>time(frac([date-time])) as Time</P><P></P><P>and you might need <A href="https://community.qlik.com/qlik-blogpost/3585">Canonical Date</A> to consolidate the various dates. More informations could you find here: <A href="https://community.qlik.com/docs/DOC-8843">How to use - Master-Calendar and Date-Values</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 14 Jul 2016 13:40:42 GMT https://community.qlik.com/t5/QlikView/Calendar/m-p/1158284#M377661 marcus_sommer 2016-07-14T13:40:42Z Re: Calendar https://community.qlik.com/t5/QlikView/Calendar/m-p/1158285#M377662 <HTML><HEAD></HEAD><BODY><P>Date# seems to have done the trick</P></BODY></HTML> Thu, 14 Jul 2016 13:46:35 GMT https://community.qlik.com/t5/QlikView/Calendar/m-p/1158285#M377662 kevbrown 2016-07-14T13:46:35Z