Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Please help

if ([Outcome Date]-[#"Treatment Registrar Date#(lf)(please fill in date format: 1-Jan-2021)"]) >150 then "OK" else "Check"

 

is not working

 

 

  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    Duration.Days([Outcome Date]-[#"Treatment Registrar Date#(lf)(please fill in date format: 1-Jan-2021)"]) >150

3 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

    Duration.Days([Outcome Date]-[#"Treatment Registrar Date#(lf)(please fill in date format: 1-Jan-2021)"]) >150

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    I want to use if condition for that logic

    [Date 2] - [Date 1]= result >150 days, "OK", "Check"