Text to Date

[My_Rebecca]

There is a text "20230301 07:30:00". How to design expression to turn it to date and time format? 

[vikasmahajan]

Hi,

you can use Date#() function :

https://ezdatamunch.com/use-simple-date-functions-qlikview-qliksense/

Thanks

Vikas

[PrashantSangle]

Hi,

try

Timestamp(Timestamp#('20230301 07:30:00','YYYYMMDD hh:mm:ss'))

Regards,

Prashant Sangle

[Hania]

hello , 

you can try this,

Date(Timestamp#('20230301 07:30:00','YYYYMMDD hh:mm:ss'),'YYYY/MM/DD hh:mm:ss')

You can give format as you want .eg: 

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[My_Rebecca]

@Hania @PrashantSangle @vikasmahajan 

Dear all, please help to kook at my scrip, anything wrong?

hour(DATE(Timestamp#("Goods Arrival",'YYYYMMDD HH:MM:SS'),'YYYY-MM-DD H:MM:SS')) as GR_Hour

[BrunPierre · Accepted solution]

Time(Frac(Timestamp#("Goods Arrival", 'YYYYMMDD hh:mm:ss')), 'h') AS GR_Hour

[PrashantSangle]

Hi,

try below 

Hour(Timestamp#("Goods Arrival",'YYYYMMDD hh:mm:ss'))

regards,

Prashant Sangle

[My_Rebecca]

dear @BrunPierre , what's the meaning of "Frac"? thanks.

[BrunPierre]

Frac() is used to remove the integer part of a number that only contains time information.

[My_Rebecca]

thanks.