Notes/Domino Fix List
 |  |
| SPR # BMGH4G6QZR | Fixed in 5.0.5 release | Regression in 5.0.2b |
Product Area: Designer Technical Area: Design - Formulas Platform: Cross Platform
SPR# BMGH4G6QZR - The @Explode (Date range) function returns a null value. This regression was introduced in 5.0.2b and is fixed in 5.0.5.
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 >
Last Modified on 05/14/2001
Go back
|