Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There is a text "20230301 07:30:00". How to design expression to turn it to date and time format?
Time(Frac(Timestamp#("Goods Arrival", 'YYYYMMDD hh:mm:ss')), 'h') AS GR_Hour
Hi,
you can use Date#() function :
https://ezdatamunch.com/use-simple-date-functions-qlikview-qliksense/
Thanks
Vikas
Hi,
try
Timestamp(Timestamp#('20230301 07:30:00','YYYYMMDD hh:mm:ss'))
Regards,
Prashant Sangle
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!
@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
Time(Frac(Timestamp#("Goods Arrival", 'YYYYMMDD hh:mm:ss')), 'h') AS GR_Hour
Hi,
try below
Hour(Timestamp#("Goods Arrival",'YYYYMMDD hh:mm:ss'))
regards,
Prashant Sangle
dear @BrunPierre , what's the meaning of "Frac"? thanks.
Frac() is used to remove the integer part of a number that only contains time information.
thanks.