Options

Applying Field Filter on field with data type DateTime

PoojaPooja Member Posts: 16
edited 2013-04-10 in NAV Three Tier
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

Comments

  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,503
    If I am not wrong it is considering "t" as "Tuesday" which is 09-04-2013 :wink:

    It was discussed earlier, I will try to find the post and get back you to..
  • Options
    PoojaPooja Member Posts: 16
    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
Sign In or Register to comment.