Dates

Updated: 2020-10-28

Formatting Dates

You can pull some dates straight from fields in the tax return. Others are constants that TaxCycle understands and calculates based on the system time on your computer and the tax year end date.

1. Place parentheses ( ) around the field code, within the double braces {{ }} (curly brackets).
2. Add format in front of the opening parenthesis ( (do not leave any space between it and the parentheses).
3. Add a comma , after the field code and before the closing parenthesis ).
4. Insert a pair of double quotes "" before the closing parenthesis ).
5. Between the double quotes "", type the date in the format in which you want it to appear, using the date of January 2, 2003 to do this (TaxCycle replaces it with the real date when it merges in the client data). Alternatively, you can use traditional date format masks. See the table on the Microsoft Custom Date and Time Format Strings page for a list of supported format strings.

Date Constants

Date Comparison

Adding Years/Months/Days

Support for Traditional Date Format Strings

TaxCycle supports traditional date format masks formatting dates in a template. You can use {{ format(CurrentClient.Info.CommonData.FileByDate, "yyyy-dd-MMM") }} or {{ format(CurrentClient.Info.CommonData.FileByDate, "2003-02-Jan") }} to insert a filing date with the format of: 2019-30-Apr:

See the table on the Microsoft Custom Date and Time Format Strings page for a list of supported format strings.