FORMULA LANGUAGE
Examples: @TimeMerge
1. This code, when added to a hostpot button, displays 02/23/2002 05:45:00 AM in the Merged date dialog box if the field date contains 02/23/02 and the field time contains 17:45:00.
@Prompt([OK];"Merged date";@Text(@TimeMerge(date;time)))
2. This code, when added to a form action, displays 02/23/2002 05:45:00 AM in the Merged date dialog box if the field date contains 02/23/02 02:30:00 and the field time contains 03/23/03 05:45:00.
@Prompt([OK];"Merged date";@Text(@TimeMerge(date;time)))
3. This code, when added to a hotspot button, displays 07/04/2002 08:30:00 PM in the Merged date dialog box if the field date contains 07/04/02, the field time contains 13:30:00, and the field zone contains Z=11$DO=0$ZX=1$ZN=Samoa (which displays as GMT-11:00). The hour is adjusted to reflect the specified time zone.
@Prompt([OK];"Merged date";@Text(@TimeMerge(date;time;zone)))
4. This code displays 01/01/2008 05:14 AM and 02/14/2008 07:45 PM in a list.
@TimeMerge([1:1:2008] : [2/14/2008]; [5:14 AM] : [7:45 PM])
See Also
@TimeMerge
Glossary
Feedback on
Help
or
Product Usability
?
Help on Help
All Help Contents
Glossary