Forum Discussion

NB3's avatar
NB3
Helper III
5 years ago
Solved

Custom/Conditional Column IF Date = Today then YES

Hello everyone,   I'm using a dataset that updates everyday and we are trying to add a column to show the following: (1) IF Date = Today then YES It would update everyday for the current day.   ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    NB3 , Try new columns like

     

    new col 1 =
    Switch( true(),
    [Date]=today() , "Yes", "No")

     

     

    new col 2 =
    Switch( true(),
    [Submitted Date].date = [Last Activity].Date , "Yes",
    [Submitted Date].date >= [Last Activity].Date && [Submitted Date].date <= [Last Activity].Date + 1 + time(9,0,0),"Yes",
    "No"
    )

  • amitchandak's avatar
    amitchandak
    5 years ago

    NB3 , let us change it a bit 

     

    new col 2 =
    Switch( true(),
    [Submitted Date].date = [Last Activity].Date , "Yes",
    [Submitted Date] >= [Last Activity].Date + time(17,0,0)&& [Submitted Date] <= [Last Activity].Date + 1 + time(9,0,0),"Yes",
    "No"
    )