Why Date function changing Time value

[musketeers]

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

[surendraj · Accepted solution]

Try with

May be..

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

[jonathandienst]

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

[sdmech81]

It should work:

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

Thanks

Sachin

[sdmech81]

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

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

[Chanty4u]

Try with

May be..

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

[musketeers]

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