column with date and time

[vireshkolagimat]

Hello All,

I have a column called TransactionDate 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.

Any suggestions how to deal in this case.

Thank you.

Regards,

Viresh

[Anil_Babu_Samineni]

May be master calendar doesn't have same format. Can you check same

[vireshkolagimat]

Hi, I have created datekey to link master calendar and fact table.

[Anil_Babu_Samineni]

How you are comparison with each date. Can you share full script?

[vireshkolagimat]

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.

[Anil_Babu_Samineni]

Yes, using Date(Date#(..)..) can work like below

Date(Date#(FieldName, 'DD-MM-YYYY', 'YYYY-MM-DD hh:mm:ss:mmm')