• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

NAB conditional format : how to compare with current date

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

  • NAB conditional format : how to compare with current date

    I'd like to have the background color of a date field have a different color

    f.e if a target date (real ISO date in the file) is 5 days overdue : green color
    if it is 10 days overdue : red color...

    so i have to compare with the current date..

    don't know how i can set this in the NAB (grid) conditional formatting for colors;...


    tried with (new Date()), but this is considered as an alfa string...

  • #2
    Hi Thierry,

    Try adding a "days(current_date) - days(targetDate) as daysLate" column (replacing "targetDate" with the name of your date column) to your data source, then you can use the daysLate value in your rule.

    Comment


    • #3
      yep.. thx a lot.. result is indeed what i need !


      thx again

      Comment

      Working...
      X