Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this
Date(MakeDate(2017,1,31), 'DD/MM/YYYY')
Timestamp and Date functions return numbers:
The connection should appear.
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?
You are right,Sunny,
What a surprise.. 🙂