Skip to main content

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!

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?

 

This worked great! Thank you!

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.

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?

Terms & Conditions