• Thanks for this interesting question.

    I knew the "special" format YYYYMMDD as I am curious and I have studied the sysjobschedules table. The format for the date and time is maybe surprising but logical ( I have worked in a factory during the 1970 years and it was a current habit ).

    For the way to convert date and time , I am choosing always this one which is executing the quickest executing way as soon as I am sure that the result is correct...