Skip to main content
Question

I need to use the following field in a date range

  • September 20, 2022
  • 0 replies
  • 462 views

I need to use the following field in a date range [cln enc date - date] It's a date-formula field.

I am trying to check for current dates, within last week (7 days)
last week 8-14 days
and then 15-21 days.

I try Boolean logic with AND and use ToDate, Today, etc but getting errors, such as mixing date and time. I just want date calculations and don't care about time of day.

I have image of the date fields there are. There are a lot of date fields, but I didn't create most of these. The [cln enc date - date] is the field that is used to match encounter records.

------------------------------
Bob T.
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Try this as a formula text field to tag the date range.

IF(
[cln enc date - date] > Today(), "Future",
Today() - [cln enc date - date] <= days(7), "Current Week",
Today() - [cln enc date - date] <= days(14), "Last Week",
Today() - [cln enc date - date] <= days(21), "Previous Week", "Older Weeks")







------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------