I've attempted to format datetime to Date (YYYY/MM/DD) without any success. All I get is a null value. I've attempted the below formatting methods:
1. Date(distribution_timestamp) as Date, 2. Date(Timestamp#(distribution_timestamp,'YYYY/MM/DD ')) as Date, 3. Date(Floor(Date#(Trim(distribution_timestamp), 'YYYY/MM/DD hh:mm:ss')), 'YYYY/MM/DD') as Date, 4. Date(distribution_timestamp,'YYYY/MM/DD') as Date 5. Date(Floor(Timestamp#(distribution_timestamp, 'YYYY/MM/DD hh:mm:ss')), 'YYYY/MM/DD') as Date, 6. Date(floor(distribution_timestamp,'YYYY/MM/DD ')) as Date,
None of which were successful.
The Date formatting in the DB I am selecting from is as per the below:
I think knowing the format in which QlikView tries to load the date is important... when you load your date without any transformation... do you see this? 2019-01-25 14:16:59.0000000. If you do, then try this
Date(Floor(Date#(Trim(distribution_timestamp), 'YYYY-MM-DD hh:mm:ss.fff')), 'YYYY/MM/DD') as Date,
Mervin, did Sunny's last post work for you? If so, please be sure to use the Accept as Solution button on his post to give him credit and confirm to others his solution worked. If you are still working on things, let us know where things stand, so we can try to come up with further ideas. About the best I have to try to help would be the following Design Blog link on Dates that may be somewhat useful.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.