Discussion Board for collaboration on QlikView Scripting.
Help nothing works. I want to convert a date and time field to time only
The field I'm converting always looks like this with dates as 00/01/1900 with the time after ie
nothing seems to extract the time only any ideas
Load like and try one of this
Timestamp#(Time,'M/D/YYYY h:mm:ss TT') as NewTime
Time(Time,'hh:mm:ss') as NewTime2,
Time(Time,'hh:mm:ss TT') as NewTime3
And it seems in excel file your Time field is not formatted as the proper Time or Date field try one of this.