Date Formula
Hello, I have the current formula that works correctly but it needs a slight adjustment: FirstDayOfMonth(AdjustMonth([Date Sold],1)) It brings back the first of the next month which is exactly ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendtry this
var number NumMonthsToAdjust =
IF(
Month([Date Sold]) <=9,1,
Month([Date Sold]) =10,3,
Month([Date Sold]) =11,2,
Month([Date Sold]) =12,1);
FirstDayOfMonth(AdjustMonth([Date Sold],$NumMonthsToAdjust))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var number NumMonthsToAdjust =
IF(
Month([Date Sold]) <=9,1,
Month([Date Sold]) =10,3,
Month([Date Sold]) =11,2,
Month([Date Sold]) =12,1);
FirstDayOfMonth(AdjustMonth([Date Sold],$NumMonthsToAdjust))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Doesn't like the 1 after the 9 says expecting date but found number!
------------------------------
Benjamin Brooks
------------------------------- MarkShnier__YouCan you post the formula and the error message?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- IF(
Month([Date Sold]) <=9,1,
Month([Date Sold]) =10,3,
Month([Date Sold]) =11,2,
Month([Date Sold]) =12,1);
FirstDayOfMonth(AdjustMonth([Date Sold],$NumMonthsToAdjust))
*** column 23 > expecting date but found number**** is the error that pops
------------------------------
Benjamin Brooks
------------------------------
- MarkShnier__YouYou need to use the whole formula :)
var number NumMonthsToAdjust =
IF(
Month([Date Sold]) <=9,1,
Month([Date Sold]) =10,3,
Month([Date Sold]) =11,2,
Month([Date Sold]) =12,1);
FirstDayOfMonth(AdjustMonth([Date Sold],$NumMonthsToAdjust))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Sorry Mark thank you!
------------------------------
Benjamin Brooks
------------------------------
