Skip to Main Content
HCL Domino 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

Status Needs Clarification
Workspace Domino Designer
Categories @Formulas
Created by Guest
Created on Mar 25, 2022

Allow @Explode for a date range using variables

According to the Help, one can use @Explode( [05/01/96 - 05/02/96] ) to create a date range value. It's only possible with scalars apparently.
Would it be possible to allow @Explode( StartDate:EndDate ), where both StartDate and EndDate are date fields? Or some other way to construct a date range in Formula language?

  • Attach files
  • Guest
    Mar 3, 2023

    Yes, would be nice. At the moment you can do it like it is done in e.g. ressource.nsf:

    @Explode( @TextToTime( "[" + @Text( StartDate ) + " - " + @Text( EndDate ) + "]" ) )

  • Guest
    Apr 2, 2022

    Sure... but not very practical in a view's 1st column, when I need to have all dates in between StartDate and EndDate in that column.

    IMHO you can kill many a good idea with a @For-loop... ;-)

  • Admin
    Thomas Hampel
    Apr 1, 2022

    How about using a @For loop?