topic Re: Why Date function changing Time value in QlikView

Why Date function changing Time value

musketeers — Thu, 02 Feb 2017 08:40:30 GMT

Hi, I have a date field in SQL database which has date ad time value. I need to display this field in Qlikview as DD-MM-YY HH:MM:SS format. I am applying below function:

DATE("Date_Field",'DD-MMM-YY HH:MM:SS') AS Date_Field_Test.

The end result I am getting is as below:

Date_Field	Date_Field_Test
1/27/2017 12:54:12 AM	27-Jan-17 00:01:12
1/27/2017 12:56:11 AM	27-Jan-17 00:01:11

Please suggest what is going wrong here or Qlikview is working as expected.

How can I get the actual values of time what I have in my SQL database table after applying Date function in qlikview?

Thanks

Rajneesh

Re: Why Date function changing Time value

surendraj — Thu, 02 Feb 2017 08:48:07 GMT

Try with

May be..

DATE("Date_Field",'DD-MMM-YY hh:mm:ss') AS Date_Field_Test.

Re: Why Date function changing Time value

jonathandienst — Thu, 02 Feb 2017 09:15:27 GMT

Correct - uppercase M is month, lowercase m is minutes.

Re: Why Date function changing Time value

sdmech81 — Thu, 02 Feb 2017 09:19:54 GMT

It should work:

Timestamp(num(Date_Field,'DD-MMM-YY hh:mm:ss')) as Date_Field_Test.

Thanks

Sachin

Re: Why Date function changing Time value

sdmech81 — Thu, 02 Feb 2017 09:22:30 GMT

MM ----is wrongly put in ur case.

Try above with time stamp ..I tested it..

Re: Why Date function changing Time value

Chanty4u — Thu, 02 Feb 2017 09:27:07 GMT

Try with

May be..

DATE((Date#(Date_Field,'DD-MMM-YY hh:mm:ss') ,'DD-MMM-YY hh:mm:ss') AS Date_Field_Test.

Re: Why Date function changing Time value

musketeers — Thu, 02 Feb 2017 10:44:00 GMT

Thanks all for the help. I can see the correct output now.