Query Data that is within a week, month and day from now

Ask for Help
1

Hi guys,

Ive seen some video’s on date filtering but essentially just want to be able to have the following :

I have a table called closed jobs and there is a closed date value in it. I have another Table called Admin Dashboard where I want to query all the closed jobs Today, This Week and This Month. In the closed jobs table I think it would be easiest in the context of the app to use this formula -

to return 0 if it is within the week. If it is 0 with a if statement column I can then say if 0 true if not false. And then query the the ‘true’ jobs and then do the same for the day and the months.

However, When I put this formula in I get this :

Screenshot 2024-07-08 at 12.37.08
Screenshot 2024-07-08 at 12.37.08736×1334 9.5 KB

So not sure why its not returning 0. Would appreciate any help on this as its pretty urgent as well as just helping out on what the formula for a day and a month would be using the same logic!

Thanks a lot guys!

Regards,

Mitch

2

Were mine any of the videos you’ve already watched?

If you need the filter to also calculate big numbers, then you’ll have to use a custom filter like I explained the video. If you’re just looking to filter a collection, then you can probably get away with using Glide’s native in-app filters with a combination of if Else columns and math column.

1 Like
3

What’s the formula?

1 Like