Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Something like this?
=date(date#('020181026 14:41:28' ,'YYYYYMMDD hh:mm:ss'), 'YYYYMMDD hh:mm:ss')