This is a migrated thread and some comments may be shown as answers.

Date filtering

2 Answers 71 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Ralph
Top achievements
Rank 1
Ralph asked on 16 May 2014, 06:51 PM


Hi,

I have DB table that stores dates in UTC.  I’m using entity framework to connect data to
a RAD grid.

We modified EF to return all dates in local time (using T4
template).  Grid displays all dates
correctly.

We have filtering issue,
using raddatepicker.  It passes dates in
local time.  By the time it gets to
entity.Selecting, DataSource.Where is already set to value based on filter.  What would be the best way to make sure
filter passes UTC dates in to DataSource?

Regards,

Ralph Wiazowski

2 Answers, 1 is accepted

Sort by
0
Maria Ilieva
Telerik team
answered on 21 May 2014, 12:28 PM
Hi Ralph,

You can do just the opposite - convert the filter value to UTC format - that way you won't need to apply the conversion to the database values.

Regards,
Maria Ilieva
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Ralph
Top achievements
Rank 1
answered on 03 Jun 2014, 09:01 PM
Do you have a an example on how to do it?
Tags
Grid
Asked by
Ralph
Top achievements
Rank 1
Answers by
Maria Ilieva
Telerik team
Ralph
Top achievements
Rank 1
Share this question
or