ChangeBillingAnchorDate
Changes the billing anchor date for a subscription.
Stored Procedure Specific Information
Execute
You need to provide the SubscriptionId to change the billing anchor date of a subscription. When no other parameters are specified, the change takes effect immediately.
EXECUTE ChangeBillingAnchorDate SubscriptionId = 'fd9d6200-bb12-43c5-9973-070bfc6f5e05'
You can optionally provide MonthlyBillingAnchorDate to specify the day of the month for billing.
EXECUTE ChangeBillingAnchorDate SubscriptionId = 'fd9d6200-bb12-43c5-9973-070bfc6f5e05', MonthlyBillingAnchorDate = 15
You can optionally provide an EffectiveDate to schedule when the billing anchor date change should take effect.
EXECUTE ChangeBillingAnchorDate SubscriptionId = 'fd9d6200-bb12-43c5-9973-070bfc6f5e05', MonthlyBillingAnchorDate = 15, EffectiveDate = '2026-08-01'
Input
| Name | Type | Required | Description |
| SubscriptionId | String | True | The ID of the subscription to update. |
| MonthlyBillingAnchorDate | Integer | False | The day of the month to change the billing anchor to. |
| EffectiveDate | Date | False | The date, in YYYY-MM-DD format, to change the billing anchor. When not set, the change takes effect immediately. |
Result Set Columns
| Name | Type | Description |
| Success | Boolean | Whether the billing anchor date change request was successfully sent to the Square API. |