Applying Field Filter on field with data type DateTime

Pooja · 2013-04-10

Hi Experts,

I m trying to apply a filter for Today on the field with data type DateTime. In classic client when i m typing on the field filter "t..t" (since it is datetime) it gets converted to "10-04-13 00:00..10-04-13 23:59" which works perfectly fine.

However if i am trying to do the same thing using RTC client it gets converted to "09-04-13 00:00..09-04-13 00:00". First of all date showing is of a previous day and end time which coming is also wrong.

Please help!!

Regards,
Pooja

mohana_cse06 · 2013-04-10

If I am not wrong it is considering "t" as "Tuesday" which is 09-04-2013

It was discussed earlier, I will try to find the post and get back you to..

Pooja · 2013-04-10

I have checked and found that, 't' stands for tuesday in DateTime Field in RTC as confirmed by you. ](*,)
Thanks for the update Mohana.

Please also help me on the time issue as well.
10-04-13 00:00..10-04-13 23:59 - Classic
09-04-13 00:00..09-04-13 00:00 - RTC

Applying Field Filter on field with data type DateTime

Comments

Categories