ParseDateTime always gives 12:00 AM

0
parseDateTime($iteratorImportBewaardersTelefoon/Jaar + '-' + $iteratorImportBewaardersTelefoon/Maand + '-' + $iteratorImportBewaardersTelefoon/Dag + ' ' + $iteratorImportBewaardersTelefoon/Uur + ':' + $iteratorImportBewaardersTelefoon/Minuten + ':' + 0 + $iteratorImportBewaardersTelefoon/AM_PM, 'yyyy-mmm-dd hh:mm:ss') Why do I always get 12:00 AM Data are integer uur <12
asked
2 answers
2

Gerard

I think the expression should be like this:

parseDateTime($iteratorImportBewaardersTelefoon/Jaar + '-' + $iteratorImportBewaardersTelefoon/Maand + '-' + $iteratorImportBewaardersTelefoon/Dag + ' ' + $iteratorImportBewaardersTelefoon/Uur + ':' + $iteratorImportBewaardersTelefoon/Minuten + ':' + '00 ' + $iteratorImportBewaardersTelefoon/AM_PM, 'yyyy-mmm-dd hh:mm:ss aa')

I made the following changes to your expression: - made the 0 into a string '00' - added a space after the seconds ('00' became '00 ') - added AM/PM indicator to the date format (aa on the end of the format)

Let me know if that helps.

Mike

answered
0

Problem solved. Thanks very much.

answered