Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everone
I'm facing an issue with the time format, the current format for the time is 06.00.00 however I can not apply any calculation in this format
Is there a way to convert this format 06.00.00 to 06:00:00?
appreciate your support
Hi
You could try this
Time(Time#('06.00.00' ,'hh.mm.ss'),'hh:mm:ss')
Hi,
To all on to BrunPierrie post, which is correct for a single value. If you have a field you want to convert you would use Time(Time#('Fieldname' ,'hh.mm.ss'),'hh:mm:ss')