Imported Date Shows Time

I am importing an Excel spreadsheet that contains a date. When I import into Domino, the field shows up containing both the date and time. How can I force it to not generate a standard time appended to this field?

Subject: RE: Imported Date Shows Time

By using a NotesDateTime object in your LotusScript code rather than a date/time variant. This has been discussed here very extensively, and if you search for NotesDateTime and my name you’ll find several versions of a more detailed explanation.

If the above does not solve your problem, we need more information about what you’re doing. If you’re not sure what information to supply, the C R I S P Y document might help you.

  • Andre Guirard, IBM/Lotus Development

Useful blog: Best Practice Makes Perfect