Soft Dates

What is a Soft Date?

In FinancialForce Billing Central, a soft date enables you to calculate recurring dates based on a unit of time such as a week, month, quarter, or year. Soft dates can consist of:

You can enter a reference, adjustment, or both using the format Reference+Adjustment. You can specify the unit of time in upper or lower case, for example, we+3d, MB-1D.

Soft dates determine the frequency and duration of plans and the billing period of billing schedules. For example, the billing term on contract lines with a recurring billing type such as Recurring Fixed or Recurring Variable is a soft date. When you activate the contract, billing schedules are created for the contract lines based on the start date, the billing term, and the number of billing terms. For more information and examples, see Calculating Billing Periods and Billing Dates.

The dates that a soft date generates are adjusted based on the calendar. This means that the resulting dates can vary depending on the interval chosen and the day from which the soft date is generated. For example, if the date is January 31, 2019 and the soft date is +1M, the next date is February 28, 2019 followed by March 31 then April 30. If the date is on a leap year such as 2020, the dates would be January 31, February 29, March 31, and April 30.

Warning:

Permission to edit soft dates ought to be restricted to a small number of users because changes to them can impact your organization's billing process.

Reference

The reference consists of two letters in upper or lower case. The first letter indicates whether the date recurs on a weekly, monthly, quarterly, or yearly basis. The second letter indicates whether the date recurs at the beginning or end of the week, month, quarter, or year. For example:

Reference

Description

WB

Sets the date to the first day of the week based on the start date.

WE

Sets the date to the last day of the week based on the start date.

MB

Sets the date to the first day of the month based on the start date.

ME

Sets the date to the last day of the month based on the start date.

QB

Sets the date to the first day of the quarter based on the start date.

QE Sets the date to the last day of the quarter based on the start date.

YB

Sets the date to the first day of the year based on the start date.

YE

Sets the date to the last day of the year based on the start date.

Note: Notes Notepad
By default, the start of a week is determined by the locale of your Salesforce OrgSalesforce organization. If a week start day is set in the Soft Date Week Start Day custom field of the FinancialForce Billing Central Settings custom setting this is used instead. See Soft Date Week Start Day.
Quarter dates are January 1- March 31, April 1 - June 30, July 1 - September 30, October 1 - December 31.

Adjustment

The adjustment consists of an operator followed by a whole number of one to three digits, which indicates whether to add or subtract from the date. This is followed by another letter that indicates whether to add or subtract days or months.

Note: Note Notepad
If you only enter an adjustment, it must be positive.

Key: xxx – Whole number consisting of one to three digits.

Adjustment

Description

+xxxD

Adds a number of days.

-xxxD

Subtracts a number of days.

+xxxM

Adds a number of months.

-xxxM

Subtracts a number of months.

Soft Date Examples

Here are some examples of soft date definitions:

Example Definition

Description

+60d

Returns a date that is 60 days after the start date.

+1m Returns a date that is one month after the start date.
+3m Returns a date that is three months after the start date.

WB+1d

Returns the second day of the week.

ME-12d

Returns a date that is 12 days before the end of the month.

The next date returned depends on the input date. For example:

  • An input date of 12th July returns 19th July.
  • An input date of 28th July returns 19th August.

QB+7d

Returns a date that is the 8th day of the quarter.
QE-2d Returns a date that is two days before the end of the quarter.

YB

Returns the first day of the year.

Here are some valid combinations of Reference+Adjustment:

Sample Soft Dates

WB

WB+0d

WB+1d

WB+999d

WB+0M

WB+1M

WB+999M

WB-0d

WB-1d

WB-999d

WB-0M

WB-1M

WB-999M

MB

MB+0d

MB+1d

MB+999d

MB+0M

MB+1M

MB+999M

MB-0d

MB-1d

MB-999d

MB-0M

MB-1M

MB-999M

QB

QB+0d

QB+1d

QB+999d

QB+0M

QB+1M

QB+999M

QB-0d

QB-1d

QB-999d

QB-0M

QB-1M

QB-999M

YB

YB+0d

YB+1d

YB+999d

YB+0M

YB+1M

YB+999M

YB-0d

YB-1d

YB-999d

YB-0M

YB-1M

YB-999M

WE

WE+0d

WE+1d

WE+999d

WE+0M

WE+1M

WE+999M

WE-0d

WE-1d

WE-999d

WE-0M

WE-1M

WE-999M

ME

ME+0d

ME+1d

ME+999d

ME+0M

ME+1M

ME+999M

ME-0d

ME-1d

ME-999d

ME-0M

ME-1M

ME-999M

QE

QE+0d

QE+1d

QE+999d

QE+0M

QE+1M

QE+999M

QE-0d

QE-1d

QE-999d

QE-0M

QE-1M

QE-999M

YE

YE+0d

YE+1d

YE+999d

YE+0M

YE+1M

YE+999M

YE-0d

YE-1d

YE-999d

YE-0M

YE-1M

YE-999M

 

+1d

+1M

+3M

-1d

-1M

-3M

Note: Note Notepad
These are examples. You can use upper or lower case, and you can enter your own number of days and months.
View TutorialsView Tutorial

Related Tasks

Creating a Soft Date

Deleting a Soft Date

Reference

Soft Date Fields

© Copyright 2009-2020 FinancialForce.com, inc. All rights reserved.
Various trademarks held by their respective owners.