I have the following Datetime field
I want to extract the Date and Time from it but i only want the hh:mm part of the time (like above)
I can get the date with this...
i thought this might help me get the time portion i need but i'm missing something somewhere...
The simple wat to check wthr u can go ahead and use Date and time functions bfr jumping into string fns,any function on dates is to add the date column in to list box then check if the values r falling on right side of list box then Qlik has taken it as date,if values fall on left side of list box then Qlik didn't.
Plss check HIC docs on date.Thanks