I have a strange behavior of the MakeDate function.
In a specific environment, the date is generated with a timestamp.
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.
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?