A formula that populates a checkbox if a date field is the next day compared to another date field in the record.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I need a formula that populates a checkbox if a date in a record is the next day compared to another date in the record.

To give contexts, I need to show the records that a 2nd visit date is scheduled 24 hours or less compared to the 1st scheduled visit date in the record. So for example;

1st Visit: 20/07/2015

2nd Visit: 21/07/2015

This would populate the checkbox because the 2nd visit took place next day compared to the 1st visit.

Photo of Andrew

Andrew

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb
[1st Visit] + Days(1) = [2nd Visit]