Date Picker - select UTC day from local date

Hi All,
I am struggling with a connection where I am trying to select all records for specific local day date from records that are stored with a UTC date and time. I have added derived field in the view that I am using that records the UTC date and time, the local date and time, the local day and the UTC day.

Is there a quick and easy way to do this using date picker? My method is clumsy - and worse still - it doesn't work!

Nick

Hi Nick,

You should be able to use the JavaScript Date object methods to do the conversion (see here). You can use the Datepicker On Date Selected box to run a function that does the conversion and saves the value to a second input.

Bob

Thanks Bob. I can see that fitting in elsewhere but I managed to get my approach sorted with derived fields in a view. That at least means the work is done up on the server.

I need that JavaScript to derive dates on data entry based on previous entries.

Thanks.

Nick