Announcement

Collapse
No announcement yet.

Help needed: why this complex expression on date calculation not working?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help needed: why this complex expression on date calculation not working?

    I want to create a reminder to assigned user before "endDate" and I tried this complex expression. But it does not work ("endDate" is a field of Date, not Datettime), why?

    And it seems this does not work only with the "equals" choice, it works well with "less than or equal" etc.

    Please help. Thanks.

    Chris


  • #2
    Hi Chris,

    Instead of "DATE" function try w/o a function.

    Comment


    • chrisjiang
      chrisjiang commented
      Editing a comment
      If I do not try Complex expression, there is no choice on choosing an Exact match of, say, *3 days before field "endDate". It will come with a range of period instead of a specific date.

  • #3
    Hello Chris,
    try to write formula this way "datetime\date(datetime\addDays(datetime\today (), 2));

    Comment


    • #4
      Originally posted by Maximus View Post
      Hello Chris,
      try to write formula this way "datetime\date(datetime\addDays(datetime\today (), 2));
      Hi Maximus,

      This does not work.

      Thanks anyway.

      Comment


      • #5
        Originally posted by yurikuzn View Post
        Hi Chris,

        Instead of "DATE" function try w/o a function.
        Can you please explain more in detail? Thanks so much!

        Comment


        • #6
          Originally posted by yurikuzn View Post
          Hi Chris,

          Instead of "DATE" function try w/o a function.
          After trying finally your way works, thanks so much!!

          I would like to attach the following screen shot for others' reference:

          Comment

          Working...
          X