KorrieClark
Qrew Trainee
6 months ago

# Formula Date > Text field

Looking for a formula that can take a date field and tell me "Next Week", " In Two Weeks", "Next Month", "Future" (aka too far beyond next month)

------------------------------
Korrie Clark
------------------------------
• If today happens to be say Friday March 29th, what result do you want in that field?   I think we need some examples of what you mean by Next Month?

------------------------------
mark.shnier@gmail.com
------------------------------
• regardless of actual calendar months i want next week to be the primary answer if it is in fact next week, but if its not in any of the other categories like 1-2 weeks next month basically just 4 weeks out would be next month, and anything beyond that would be too far into the future

------------------------------
Korrie Clark
------------------------------
• OK, not tested but try this.

var date MyDate = [your date field here];

var date SundayOfDateWeek = FirstDayOfWeek(\$MyDate);

var Date SundayOfToday = FirstDayOfWeek (Today());

IF(

\$MyDate < Today(), "Past",

\$SundayOfDateWeek = \$SundayOfToday, "This Week",

\$SundayOfDateWeek = \$SundayOfToday, + Weeks(1), "Next Week",

\$SundayOfDateWeek = \$SundayOfToday, + Weeks(2), "Third Week Out",

\$SundayOfDateWeek = \$SundayOfToday, + Weeks(3), "Fourth Week Out",

\$SundayOfDateWeek > \$SundayOfToday, + Weeks(3), "4+ Weeks Out")

If you want this to be sorted you can add some extra spaces in front of the words tpo dorce the sort or else number them like "0. Past" or "1. This Week"

------------------------------