MakeDate issue: can't get rid of timestamp

[dafnis14]

Hi,

I have a strange behavior of the MakeDate function.

In a specific environment, the date is generated with a timestamp.

for example,

MakeDate(2017,1,31) is generating : 31/01/2017 12:00:00 AM.

All the combinations of floor can't remove it.

This is really important for me.

Would appreciate your help.

Thanks!

[sunny_talwar · Accepted solution]

Try this

Date(MakeDate(2017,1,31), 'DD/MM/YYYY')

[dafnis14]

Hi Sunny,
Thanks for your prompt reply!
If you do Timestamp(Date(MakeDate(2017,1,31), 'DD/MM/YYYY'))
then you still see the hour. The issue is that such a date can't be linked to a date without timestamp ..
Am I missing something?

[MindaugasBacius]

Timestamp and Date functions return numbers:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/FormattingFunctions/Ti...

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/FormattingFunctions/Da...

The connection should appear.

[sunny_talwar]

12:00:00 AM is essentially nothing but 0 hours 0 minutes and 0 seconds. If you use the time stamp function... it will show you the hours, minutes and seconds. What is wrong with that?

[dafnis14]

You are right,Sunny, 

What a surprise.. 🙂