topic column with date and time in QlikView https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386269#M422087 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have a column called <STRONG>TransactionDate</STRONG> in my Master and transaction table and it's storing the values in YYYY-MM-DD hh:mm:ss:mmm format. When i try to compare the data between the backend database and Qlikveiw, the results won't be proper.</P><P></P><P>Any suggestions how to deal in this case.</P><P></P><P>Thank you.</P><P></P><P>Regards,</P><P>Viresh</P></BODY></HTML> Tue, 28 Nov 2017 10:51:57 GMT vireshkolagimat 2017-11-28T10:51:57Z column with date and time https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386269#M422087 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have a column called <STRONG>TransactionDate</STRONG> in my Master and transaction table and it's storing the values in YYYY-MM-DD hh:mm:ss:mmm format. When i try to compare the data between the backend database and Qlikveiw, the results won't be proper.</P><P></P><P>Any suggestions how to deal in this case.</P><P></P><P>Thank you.</P><P></P><P>Regards,</P><P>Viresh</P></BODY></HTML> Tue, 28 Nov 2017 10:51:57 GMT https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386269#M422087 vireshkolagimat 2017-11-28T10:51:57Z Re: column with date and time https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386270#M422088 <HTML><HEAD></HEAD><BODY><P>May be master calendar doesn't have same format. Can you check same</P></BODY></HTML> Tue, 28 Nov 2017 11:14:33 GMT https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386270#M422088 Anil_Babu_Samineni 2017-11-28T11:14:33Z Re: column with date and time https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386271#M422089 <HTML><HEAD></HEAD><BODY><P>Hi, I have created datekey to link master calendar and fact table.</P></BODY></HTML> Tue, 28 Nov 2017 11:32:49 GMT https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386271#M422089 vireshkolagimat 2017-11-28T11:32:49Z Re: column with date and time https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386272#M422090 <HTML><HEAD></HEAD><BODY><P>How you are comparison with each date. Can you share full script?</P></BODY></HTML> Tue, 28 Nov 2017 11:35:02 GMT https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386272#M422090 Anil_Babu_Samineni 2017-11-28T11:35:02Z Re: column with date and time https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386273#M422091 <HTML><HEAD></HEAD><BODY><P>Hi, can we maintain the similar date format in Qlikview as well. We are reading the data from 8:00 AM to 8:00 AM. For example, yesterdays data will be from 27/11/2017 8:00 AM to 28/11/2017 8:00 AM.</P></BODY></HTML> Tue, 28 Nov 2017 11:36:09 GMT https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386273#M422091 vireshkolagimat 2017-11-28T11:36:09Z Re: column with date and time https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386274#M422092 <HTML><HEAD></HEAD><BODY><P>Yes, using Date(Date#(..)..) can work like below </P><P></P><P><STRONG>Date(Date#(FieldName, 'DD-MM-YYYY', 'YYYY-MM-DD hh:mm:ss:mmm')</STRONG></P></BODY></HTML> Tue, 28 Nov 2017 11:38:28 GMT https://community.qlik.com/t5/QlikView/column-with-date-and-time/m-p/1386274#M422092 Anil_Babu_Samineni 2017-11-28T11:38:28Z