Time Formatting

[anthony_kinsell]

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?

[Anonymous]

Anthony

Try something like :

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

Best Regards,     Bill

[MayilVahanan · Accepted solution]

Hi

Hope ActivityDateTime is datetime field, if so try like this

Time(ActivityDateTime) As Time;

[anthony_kinsell]

Thanks,

I was overcomplicating it!!