Simple Date Calculation

[Joseph31]

I need some simple help:

How do you subtract two dates and then if the answer is Less than 180 days return a "1" to a field is more do nothing.

I have attached what I thought would work but as you can tell if you know what you are doing it does not work at all.

Case (

Policies::Current_Date - Background_Check_Chart_Broker::Requested_Search_Date ≤ Day ( 180 ); "1")

Thank you,

Joseph

[comment]

You don't need the Day() function (which always returns a number between 1 and 31), and you don't need the Case() function:

Policies::Current_Date - Background_Check_Chart_Broker::Requested_Search_Date ≤ 180

[Joseph31]

With out the case function how do I get this calculation to return "1" for a check box to be checked?

Thank you,

Joseph

[comment]

From Filemaker Help:

Comparison operators

Comparison operators compare two values and return either True or False. (Such expressions are sometimes called Boolean expressions.) Mathematically, a result of True equals 1 and False equals 0.

[Joseph31]

Thank you for the help...

Looks like it works now...

Thank you,

Joseph