Controls

Re: DateTime Picker - Setting Time based on value of Field A but Time based on value of Field B - Possible???

csigler — Thu, 18 Oct 2012 19:58:44 GMT

It does! Will give it a try.

Many thanks!

Re: DateTime Picker - Setting Time based on value of Field A but Time based on value of Field B - Possible???

Anson Hidajat — Thu, 18 Oct 2012 19:50:51 GMT

I think you can use some clever string parsing to accomplish this. You can create a rule on the time field (morning, evening, etc.) when it changes to parse out the date part (use substring) then add on the time piece based on what was selected like 07:00 if its morning. Hope that makes sense!

DateTime Picker - Setting Time based on value of Field A but Time based on value of Field B - Possible???

csigler — Thu, 18 Oct 2012 19:46:31 GMT

I have a scheduling form that I created where workflow is triggered and updates a SharePoint calendar. The problem is TIME. It is just too much entry for my users and they really don't need to be percise down to the minute.

Sooooo I would like to give them a Date Picker and a dropdown with values of Morning, Afternoon, and All Day. Then, so the calendar will be updated correctly, have two hidden date/time fields.... Start Time and End Time. When the user enters the Trip date it sets Start Time (date) and End Time (date) to that value (date). BUT when the user selects "Morning" from the dropdown it sets Start Time (time) to 7 a.m. and End Time (time) to 12 p.m.

Am I over thinking this? Any suggestions would be appreciated.

Corrie