Recently I found a request for Time Zone Converter. But couldn't locate it, just after creating it. Hence posting it as a separate topic.
This application 'Time Zone Converter' converts CET time to EST,PST and CET.
A Form 'Convert Time' will have the following fields :
Name (SingleLine) Date (Date Field) Time (SingleLine) : Can fill it with 24 hour format like 23:45 or 05:00 etc
TimeZone (Dropdown having values 'EST,PST,CET')
CET(SingleLine) : The converted time will be updated here. It is in dd-MMM-YYYY HH:MM:SS format. I included the date also here so that if the input Time and TimeZone are such just the next day has to be selected, it will be shown accordingly in the CET field.
Working : The script is implemented in the 'onUserInput' action of the TimeZone field. i.e If you fill the Date, Time and select the TimeZone to 'EST' or 'PST' or 'CET', the CET Field will be updated accordingly. Then the user can submit the data as a record.
I have attached the ds file. Do let us know in case of any clarifications.