en · de

SnTT: Create date values without time information via LotusScript

by Bernd,
assono GmbH, Standort Hamburg,


Show-n-Tell Thursday If date values are written to a field via LotusScript they always include also a time value. If there is no time value it is automatically set to "00:00:00". Normally this is okay. But if you want to display the document in a calendar view the result could be unwanted. Because the entry will be shown at "00:00:00". ("12:00 Midnight" for our American friends)

The calendar view works as designed. If the field contains only a date value the entry will be displayed above the time slots. If there is a date and a time value the entry will be at that time in the time slot. What a pity that there is no way to create only a date value with out time via LotusScript.

A picture named M3

Once more Evaluate comes for rescue.


The main point is not to write the return value from Evaluate into the field. Instead use @SetField directly in the Evaluate statement.

Dim eval As Variant
eval = Evaluate(|@SetField("DateLS"; @today);|, doc)

And here it is a date value calculated with LotusScript without a time value.
A picture named M2

Technical article IBM Notes IBM Notes Traveler Development

You have questions about this article? Contact us: blog@assono.de

Sie wollen eine individuelle Beratung oder einen Workshop? Read more

More interesting entries

Any questions? Contact us.

If you want to know more about our offers, you can contact us at any time. There are several ways to contact us for a non-binding first consultation.

assono GmbH

Location Kiel (headquarters)
assono GmbH
Lise-Meitner-Straße 1–7
24223 Schwentinental

Location Hamburg
assono GmbH
Bornkampsweg 58
22761 Hamburg

Phone numbers:
Human resources department: +49 4307 900 407
Marketing department: +49 4307 900 411

E-Mail adresses:
contact@assono.de
bewerbung@assono.de