Discussion Board for collaboration related to QlikView App Development.
I've got what I think will be a quite straightforward query. I'm trying to get just the time element of the below:
The filed that gives this value is named 'ActivityDateTime ' so I put in the following formula:
Time (Right(ActivityDateTime,8)) as ViewingTime,
This works only for some of my data which find odd?
Hope ActivityDateTime is datetime field, if so try like this
Time(ActivityDateTime) As Time;
View solution in original post
Try something like :
time(ceil(date(date#('22/11/2012 10:30:00' ; 'DD/MM/YYYY hh:mm:ss')
Best Regards, Bill
I was overcomplicating it!!