Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

dafnis14
Contributor III

MakeDate issue: can't get rid of timestamp

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!

Labels (3)
1 Solution

Accepted Solutions
Highlighted

Re: MakeDate issue: can't get rid of timestamp

Try this

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

Re: MakeDate issue: can't get rid of timestamp

Try this

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

Re: MakeDate issue: can't get rid of timestamp

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
Valued Contributor III

Re: MakeDate issue: can't get rid of timestamp

Re: MakeDate issue: can't get rid of timestamp

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
Contributor III

Re: MakeDate issue: can't get rid of timestamp

You are right,Sunny, 

What a surprise.. 🙂