Forum Discussion

mskarka's avatar
mskarka
Regular Visitor
3 years ago

Format date in table based on current date

I have table vizualization with column "date". I want to change color of the date value based on current date. 
So for example:
IF "date" > TODAY then (show red)
- or something like that...


I thought it should be somewhere here... but not? 


Thx in Advance for help.

 

Need Help

2 Replies

  • krishb1414's avatar
    krishb1414
    Helper III
    3 years ago

    try this measure
    measure = IF(date > Today(),1,0)

     

    and go to conditional formatting select field value as this measure and choose these conditions
    1) measure = 1, Red

    2) measure = 0, Green

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mskarka's avatar
    mskarka
    Regular Visitor
    3 years ago

    Just to be sure if I understand corretly. You suggest to add new column and filtr/format based on that... Correct? Okay then 🙂 thx