Help needed working with dates.
I am new to QuickBase and need some help with a formula. I found one component but need help with the rest. The formula I am looking for will determine if a date is the last Thursday of a month. ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp
var number NumDaysInMonth = LastDayOfMonth([my date field]) - FirstdayOfMonth([my date field]) +1;
DayOfWeek([my date field]) = 4 and ($NumDaysInMonth - Day([my date field]) < 7)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var number NumDaysInMonth = LastDayOfMonth([my date field]) - FirstdayOfMonth([my date field]) +1;
DayOfWeek([my date field]) = 4 and ($NumDaysInMonth - Day([my date field]) < 7)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thank you,
Your solution was close to what I found shortly after posting,
if(DayOfWeek(date) = 4 and (Day(LastDayOfMonth(date) - Day(date) < 7) ...
The "LastDayOfMonth" was the piece I was missing.
Thank you for your help!
------------------------------
Paul Peterson
------------------------------
