topic Re: Time Format in QlikView

Time Format

Nadiyah — Tue, 10 Jan 2023 11:40:53 GMT

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

Re: Time Format

BrunPierre — Tue, 10 Jan 2023 12:08:59 GMT

You could try this

Time(Time#('06.00.00' ,'hh.mm.ss'),'hh:mm:ss')

Re: Time Format

Bill_Britt — Tue, 10 Jan 2023 12:14:38 GMT

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')