topic Re: Dates in QlikView https://community.qlik.com/t5/QlikView/Dates/m-p/1425645#M813429 <HTML><HEAD></HEAD><BODY><P>The complete script</P></BODY></HTML> Fri, 15 Sep 2017 12:38:49 GMT sunny_talwar 2017-09-15T12:38:49Z Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1425639#M813423 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have a Q.V. application where I am linking a date from my dataset to a calendar reference table.</P><P></P><P>The calendar reference table date is coming from a SQL table and is set to datetime e.g. 2013-01-01 00:00:00.000</P><P></P><P>My dataset is in Excel and I am taking it into Q.V.&nbsp; The date in Excel looks like a date time e.g. 26/04/2017 00:00 all dates are populated and generally the time is set to 00:00 but there are some times populated occasionally e.g. 23:59.</P><P></P><P>When I am linking,&nbsp; the dates with the occasional time portion filled out are not returning any data from the calendar reference table. </P><P></P><P>It is like a mismatch of data types. I've tried a few things but nothing has worked.&nbsp; Does anyone have any ideas?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1425639#M813423 2020-11-25T16:16:04Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1425640#M813424 <HTML><HEAD></HEAD><BODY><P>May be use Floor() function to remove the time component of the date and time field?</P></BODY></HTML> Fri, 15 Sep 2017 11:49:13 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1425640#M813424 sunny_talwar 2017-09-15T11:49:13Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1425641#M813425 <HTML><HEAD></HEAD><BODY><P>Hi Sunny thanks for your reply. I tried it but it doesn't work.</P></BODY></HTML> Fri, 15 Sep 2017 11:56:16 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1425641#M813425 2017-09-15T11:56:16Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1425642#M813426 <HTML><HEAD></HEAD><BODY><P>What script did you use?</P></BODY></HTML> Fri, 15 Sep 2017 11:57:08 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1425642#M813426 sunny_talwar 2017-09-15T11:57:08Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1425643#M813427 <HTML><HEAD></HEAD><BODY><P>Floor(date)</P></BODY></HTML> Fri, 15 Sep 2017 12:04:04 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1425643#M813427 2017-09-15T12:04:04Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1425644#M813428 <HTML><HEAD></HEAD><BODY><P>Floor(date)</P></BODY></HTML> Fri, 15 Sep 2017 12:06:18 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1425644#M813428 2017-09-15T12:06:18Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1425645#M813429 <HTML><HEAD></HEAD><BODY><P>The complete script</P></BODY></HTML> Fri, 15 Sep 2017 12:38:49 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1425645#M813429 sunny_talwar 2017-09-15T12:38:49Z