Number of bookings within current week


Is there an easy workaround to find the number of bookings within current week:

count if booking date is more than this sunday and less than next sunday.

knowing that sunday =0, I couldn’t implement this constraint:

booking date <= 0- current date

Hi there, @amna… the same solution I mentioned in this post should also work for you…

Extract the week from the booking date and compare it to the extracted week from the current date/time.

Hope this helps!