topic Re: Date Conversion Issues in QlikView

Date Conversion Issues

umashankarus — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I am getting incorrect, null and some times correct date conversion for various data rows

Correct:

Date(Floor(Timestamp#('1/23/2018 12:01:30 PM', 'MM/DD/YYYY HH:MM:SS TT')),'MM/DD/YYYY')

Result = 01/23/2018

Incorrect

Date(Floor(Timestamp#('1/23/2018 2:06:00 PM', 'MM/DD/YYYY HH:MM:SS TT')),'MM/DD/YYYY')

Result = 06/23/2018

Null

Date(Floor(Timestamp#('1/22/2018 3:52:00 PM', 'MM/DD/YYYY HH:MM:SS TT')),'MM/DD/YYYY')

Result = -

Can you pl point to the issue here ?

Thanks for the help

rubenmarin — Mon, 29 Jan 2018 16:59:41 GMT

Hi, try setting the time mask in lower case:

=Date(Floor(Timestamp#('1/23/2018 2:06:00 PM', 'MM/DD/YYYY hh:mm:ss tt')),'MM/DD/YYYY')

umashankarus — Mon, 29 Jan 2018 17:38:22 GMT

That works

Thanks for the help