to_string( field, '%H-%M-%S' ) always reformatting into to_string(field,'%h-%m-%s')

I am entering the following formula (using 5.2):

to_string(add_seconds (01/01/1970 00:00:00 ,to_integer (1000) ),'%H:%M:%S' ) 

but after saving it automatically reformat the formula to be 

to_string(add_seconds (01/01/1970 00:00:00 ,to_integer (1000) ),'%h:%m:%s' ) 

The new format is however causing the following result: "Jan:01:-24200".

 

Do you have any suggestion how to prevent this behavior?

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • Status Answered
  • 10 days agoLast active
  • 6Replies
  • 22Views
  • 4 Following