Forum Discussion
MichaelTamoush
Qrew Captain
Is the current field a text string, and can you be sure it will always be in the same format, and it will be spelled the same?
ie: Will you ever have Sept. 2021 and September 2021 or perhaps Sept 21?
------------------------------
Michael Tamoush
------------------------------
ie: Will you ever have Sept. 2021 and September 2021 or perhaps Sept 21?
------------------------------
Michael Tamoush
------------------------------
MattMakris
4 years agoQrew Assistant Captain
It's a text field (multiple choice) and the spelling/format will always be constant.
------------------------------
Matt Makris
------------------------------
------------------------------
Matt Makris
------------------------------
- MarkShnier__You4 years agoQrew LegendI think that Mike is west cost so I will take the early shift here.
var text MonthName = Trim(Left([my text string]," "));
var number YYYY = ToNumber(Right([my text string]," "));
var number MonthNumber =Case($MonthName,
"January", 1,
"February", 2,
etc
"December", 12);
var date FirstDayOfMonthStringDate = Date($YYYY, $MonthNumber, 1)
IF(
$FirstDayOfMonthStringDate < FirstDayOfMonth(Today()), "Past",
$FirstDayOfMonthStringDate = FirstDayOfMonth(Today()), "Present",
$FirstDayOfMonthStringDate > FirstDayOfMonth(Today()), "Future")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- MichaelTamoush4 years agoQrew CaptainThanks Mark! I lost track of time and discussion posts lol!
------------------------------
Michael Tamoush
------------------------------