Skip to main content
Solved

Date Range Verifier is Excluding Data Within its Supposed Range

  • June 20, 2025
  • 4 replies
  • 69 views

Forum|alt.badge.img+2

Hi! good day!

I am currently using the formula below to determine if a record/records is within last weeks Sunday to Saturday. Sunday being start of the week and Saturday being end of the week.

 

AND(

       IS_AFTER(

           {Time in},

           DATEADD(

               DATEADD(

                   TODAY(),

                   -WEEKDAY(TODAY(), "Sunday") - 7,

                   "days"

               ),

               0,

               "days"

           )

       ),

       IS_BEFORE(

           {Time in},

           DATEADD(

               DATEADD(

                   TODAY(),

                   -WEEKDAY(TODAY(), "Sunday") + 0,

                   "days"

               ),

               0,

               "days"

           )

       )

   )

 

If today is the 20th of June then my Current formula will tag my June 8 , 8AM record as false. 

If I adjust the time to 8:30AM, formula will tag it as true,

 

would like the formula to include the entire day of sunday up to the entire day of saturday.

 

Appreciate the help!

Best answer by TheTimeSavingCo

Hmm sounds like a timezone related thing.  Try changing your Date Time field so it uses GMT as the timezone and see whether that helps?

 

4 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hmm sounds like a timezone related thing.  Try changing your Date Time field so it uses GMT as the timezone and see whether that helps?

 


Forum|alt.badge.img+2
  • Author
  • New Participant
  • June 20, 2025

This worked great! Thank you!


Forum|alt.badge.img+2
  • Author
  • New Participant
  • June 23, 2025

Hi, ​@TheTimeSavingCo!

         Encountered bigger problems using GMC/UTC. The forms used to fill these records use the device’s time zone. All date fields have been adjusted to my time zone already and the initial problem has recurred. The time zone I use is Asia/Manila if that is any help.


TheTimeSavingCo
Forum|alt.badge.img+31

Hmm, so all your date time fields are now set to Asia/Manila?  If so, try doing a DATEADD with a -8 hours so that you’re converting the time back into GMT before the check?