Skip to main content
Question

How to generate date that is exactly one month after numeric field that represents day of month

  • March 25, 2020
  • 0 replies
  • 33 views
MattMakris
Forum|alt.badge.img+7
I am trying to calculate a date that is one month after a date in another field. Here are the fields being used:

  1. Day of the month (numeric field)
  2. Next month start date (date formula)

If the `Day of the month` field is "6" and the current month is March 2020, then `Next month start date` should be "3-6-2020.

Any help on this is much appreciated, thanks!

------------------------------
Matt Makris
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • March 25, 2020
Conveniently, there is a function for that.

var date ThisMonthdate = Date(Year(Today()),Month(Today()), [Day of the month]);

AdjustMonth($ThisMonthdate,1)


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement