Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Time Formatting

I've got what I think will be a quite straightforward query. I'm trying to get just the time element of the below:

22/11/2012  10:30:00

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?

1 Solution

Accepted Solutions
Highlighted

Re: Time Formatting

Hi

Hope ActivityDateTime is datetime field, if so try like this

Time(ActivityDateTime) As Time;

View solution in original post

4 Replies
Highlighted
Creator
Creator

Re: Time Formatting

Highlighted

Re: Time Formatting

Anthony

Try something like :

     time(ceil(date(date#('22/11/2012 10:30:00' ; 'DD/MM/YYYY hh:mm:ss')

Best Regards,     Bill

Highlighted

Re: Time Formatting

Hi

Hope ActivityDateTime is datetime field, if so try like this

Time(ActivityDateTime) As Time;

View solution in original post

Highlighted
Creator
Creator

Re: Time Formatting

Thanks,

I was overcomplicating it!!