date formats

[ilanbaruch]

hi all 

based on same field i am creating to date fields one is ok and the other add a '0' prefix.. 

date(datefield ,'YYYYYMMDD hh:mm:ss')

retrieves :

1. 020181026 14:41:28

2. 20181030 17:22:03

any ideas ?

[Gysbert_Wassenaar · Accepted solution]

Why are you using five Y's instead of the usual four in your date format string?

[haupenthals]

Something like this?

=date(date#('020181026 14:41:28' ,'YYYYYMMDD hh:mm:ss'), 'YYYYMMDD hh:mm:ss')

[ilanbaruch]

Thank you for your enlightenment!