KNOWLEDGE BASE

DATEPARSE Returns 0:00 for 12:00


Published: 30 Aug 2016
Last Modified Date: 30 Aug 2016

Question

DATEPARSE Returns 0:00 for 12:00

For example DATEPARSE('hhmm' , [TIME])     *TIME=12:00*
The function returns 00:00:00 instead 12:00:00

 

Answer

Use H instead of h for hour. For example: DATEPARSE('HHmm' , [TIME])
Did this article resolve the issue?