# I need assistance with a formula?

• 0
• Question
• Updated 3 years ago
Formula needed to indicate a date.

DW 1 is billed on xx/xx/xxxx.
If this date is billed on or after xx/01/xxxx and on or before xx/15/xxxx, return date of xx/10/xxxx of next month.

OR
DW 1 is billed on xx/xx/xxxx.
If this date is billed on or after xx/16/xxxx and on or before xx/31/xxxx, return date of xx/25/xxxx of next month.
• 600 Points

Posted 3 years ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 69,612 Points
Try this for a due date calculation

var date BillingDate = [my field with the Billing Date];

var date SameDayNextMonth = (AdjustMonth(\$BillingDate,1);

If(Day(\$BillingDate) <= 15, Date(Year(\$SameDayNextMonth), Month(\$SameDayNextMonth),10),

Date(Year(\$SameDayNextMonth), Month(\$SameDayNextMonth),25))

,
• 600 Points
Thank you.  Missing a closing parentheses after:

Once this was fixed, appears to work.

thank you

QuickBaseCoach App Dev./Training, Champion

• 69,612 Points
OK, great.  Actually I should have written it as
var date SameDayNextMonth = AdjustMonth(\$BillingDate,1);