Forum Discussion
MattMakris
Qrew Assistant Captain
It's a text field (multiple choice) and the spelling/format will always be constant.
------------------------------
Matt Makris
------------------------------
------------------------------
Matt Makris
------------------------------
MarkShnier__You
4 years agoQrew Legend
I 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
------------------------------
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
------------------------------