Technote Number: 1101554
Problem:
This issue was reported to Lotus Quality Engineering, and was addressed in
Notes 5.0.5 Client and Domino 5.0.5 Designer.
The problem occurs because the @TextToTime function is not evaluating
correctly. If you are evaluating like dates, the workaround is to include a
time value along with the date; or you can add an additional parameter to test
for the null value produced by this problem and produce the result you want.
Time Date fields will not have a time portion if the date input value was
generated in any of the following ways:
- the Time field is set to display only the Date format
- the Time field is set to Time and Date, but only a date value was entered
- the date value is input via a date calendar control within a Layout Region
Workaround:
You can use a formula check to see whether a time value has been set or not.
This can be accomplished using the @Hour function. The @Hour, @Minute and
@Seconds functions will return -1 if a time has not been set.
For example, given a date field called "Startdate", the formula below sets the
time value of the field to 1 AM if no time was specified:
@If(@Hour(Startdate)=-1;
@Time(@Year(Startdate);@Month(Startdate);@Day(Startdate);1;0;0); Startdate)
The above formula logic could also be applied to a field's Input Translation
formula.
Supporting Information:
Related Documents:
More >
|  |
|
|
|
|
|