calculating dates

jbryer

I'm trying to build a beast mode field that does the following...

When the date_created is great than 131

and the last payment date is between 55 and 86 days, then we are in month 3

DashboardDude

Hi @jbryer ,

I think the main thing you're missing is comparing the dates from today using CURDATE()

I made a video for you: https://www.loom.com/share/1190186ea57a42efb49fb772bb5f0b84

John Le

You're only one dashboard away. 

More video solutions at: https://www.dashboarddudes.com/pantry

DashboardDude

Hi @jbryer ,

I think the main thing you're missing is comparing the dates from today using CURDATE()

I made a video for you: https://www.loom.com/share/1190186ea57a42efb49fb772bb5f0b84

John Le

You're only one dashboard away. 

More video solutions at: https://www.dashboarddudes.com/pantry