Checking dates and comparing fields

Question

I am having trouble trying to use the dates field in a scheduler app and then check a different field in my form to see if it is the same the as the day before and after. If the fields are the same/open/null then it would allow the request to go through, otherwise it would prevent the scheduling because of the secondary field. Is it possible to do this on the quickbase platform?

MarkShnierYou · Answer

Yes, easily done, but can you express more clearly the logic that you want to have and we can help you with the formula syntax.

For example, if we make a formula checkbox field called called [OK to Allow Request] we then need to list the conditions and if they would make the checkbox checked or unchecked. We also need to understand if the day before is calendar days or business days.

IF(
[date field 1]=[date field 2], true,
[date field 1]= [date field 2]- days(1), true ).

etc.. need to have you say your complete logic listed by each test that needs to be done in the sequence they need to be done..

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community