Shoulder Surf Sessions #1: Building a Visual Food Log (in Under 5 Minutes)

I use a few formulas in the video to calculate if the date is within “This Week”, “This Month” and “This Year”. We use these formulas to display all of the food entered for the current week (Sunday – Saturday). Here are the formulas used in the video:

This Week

formatDate(prop("Date"), "w") == formatDate(now(), "w")

This Month

formatDate(prop("Date"), "M") == formatDate(now(), "M")

This Year

formatDate(prop("Date"), "YYYY") == formatDate(now(), "YYYY")