#dominoforever | Product Ideas Portal

 

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

Input and output date and time values ​​in ISO8601-compliant format

If you use the LotusScript NotesDominoQuery class to set the date and time in a DQL query, you must type an ISO8601-compliant format.

 

@dt(‘2021-01-01T00:00:00.00+0900’)

 

The date and time that we usually see in the document properties and view columns are the values ​​converted to local time, and the time zone value may not be displayed there.

 

The ISO format is redundant such as time zone and milliseconds, and the separator is a hyphen instead of a slash. It is confusing because it is different from the date and time format that we are used to in LotusScript.

 

In the future, when using AppDev Pack to work with Domino and other systems, there will be more opportunities to exchange ISO format dates and times.

 

There are two ideas for converting to ISO8601-compliant dates and times:

 

 1. Type “ISO Date Time” in the second element of the format function

Print Format(Now, “ISO Date Time”)            ‘ Output: 2019-09-22T02:02:00.00+0900

 

2. Extending the NotesDateTime class that allows you to input and output values ​​in ISO8601-compliant format

Output:

    Dim ndt As New NotesDateTime(Now)

    Print ndt.ISOTime              ‘Output: 2019-09-22T02:02:00.00+0900

Input:

    Dim ndt As New NotesDateTime(“2019-09-22T02:02:00.00+0900”)

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Sep 21 2019
  • Needs review
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    17 Jan 03:17pm

    Circulating internally