|A Field to hold DateTime value can be created from a field holding Date value and a picklist field holding Time values. There are some consideration and limitation for this formula.
- Consider the time populates as Picklist not Textbox. Refer the attached file "Time (Picklist Sample Values).txt".
- Assume that below 2 fields are the INPUT for the requirement:
|Field Name||Field Type||Values (example)|
|Start TIME||Picklist||12:55 PM|
- Consider Timezone for the user (under Name-> My Settings -> Language & Time Zone) as “(GMT-05:00) EST (America/New_York)”.
- For other Timezones, change the occurrence of “5” in attached formulas as per below table:
|Time Zone||Replace +5 with (from below formulas)|
First version of this article will only work for Timezone with “GMT +/- XX:00” format i.e. this will not work for 12 Timezones like “GMT+05:30”, "GMT + 13:45", “GMT-09:30” but will work for rest all like "GMT + 14:00", "GMT + 15:00".
This would be the OUTPUT for this requirement:
| Field Name||Field Type||Values (example)|
|Start DATE/TIME||Date/Time||23/12/2013 12:55 PM|