Forum Discussion
Pravin1137
May 08, 2021Copper Contributor
Time
Hi,
I am creating report for my organization.I have given date/time format like dd/mm/yyyy hh/mm/ss .
The job runs automatically on daily basis. When the job runns on 12:00:00 AM It is not showing time it just showing date not time but client wants time also like 13/04/2021 00:00:00
Any help will be appreciated.
Thanks in advance.
I am creating report for my organization.I have given date/time format like dd/mm/yyyy hh/mm/ss .
The job runs automatically on daily basis. When the job runns on 12:00:00 AM It is not showing time it just showing date not time but client wants time also like 13/04/2021 00:00:00
Any help will be appreciated.
Thanks in advance.
- Dates/times are stored as double datatype numbers e.g. 44324.8043171296 for 8 May 2021 19:18 (7:18 PM)
The integer part is the number of days since 30 Dec 1899 and the decimal part is the time as a portion of a whole day.
At exactly midnight tonight it will be 44324.00 which will be displayed as 44324
If you wish the time to ALWAYS be displayed you will need to format the display to do so
Alternatively, change the time the job runs to e.g. 12:01 AM (00:01) - Gustav_BrockBrass Contributor
- Hi Gustav. Thanks for adding that. I thought I had done so but clearly not