Skip to main content

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
Specialist
Specialist

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
sunny_talwar

Try this

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

View solution in original post

5 Replies
sunny_talwar

Try this

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

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?
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
Specialist
Specialist
Author

You are right,Sunny, 

What a surprise.. 🙂