It is possible to populate the {DATE} or {SIGNDATE} tag in additional formats. The tags will populate the information in a default format of Month (abbreviated) Day, Year or Aug 02, 2016 for example. You are able to change the format if you wish.
What if I wish to change the format to 'Day - Month (full spelling) - Year'?
I would place the tag on the document template as {DATE:d - F - Y||today} the date would then populate as "02 - August - 2016".
The basic format you are using is {DATE:**Date Code**||**date**}.
Populating Future Dates
You can also make dates for the future populate using this method.
What if you want the date to populate 10 days from today?
{DATE:m d, Y||Today + 10 days} = "Aug 12, 2016" (assuming today is the 2nd).
6 months from today
{DATE:m d, Y||Today + 6 Months} = "Feb 12, 2016"
Populating Future Dates Related To Other Tags
You can also replace "Today" with another date tag. For example you have a tag labeled "Example Date", you can include this as part of the DATE tag so you can populate the information formatted as you desire.
Lets assume "Example Date" has a value of 1/12/2016 but you want it to populate as "January 1st, 2016" you would add the tag as {DATE:F jS, Y||{CF:Example Date}}. You are replacing "Today" as used in earlier examples for the tag {CF:Example Date}, this will then populate the value of Example Date as "January 1st, 2016".
Date Codes
Below is a list of the available codes and an explanation of what they will populate. You will use these as part of the tag to format the information that is populated.
- d - The day of the month (from 01 to 31)
- D - A textual representation of a day (three letters)
- j - The day of the month without leading zeros (1 to 31)
- l (lowercase 'L') - A full textual representation of a day
- N - The ISO-8601 numeric representation of a day (1 for Monday, 7 for Sunday)
- S - The English ordinal suffix for the day of the month (2 characters st, nd, rd or th. Works well with j)
- w - A numeric representation of the day (0 for Sunday, 6 for Saturday)
- z - The day of the year (from 0 through 365)
- W - The ISO-8601 week number of year (weeks starting on Monday)
- F - A full textual representation of a month (January through December)
- m - A numeric representation of a month (from 01 to 12)
- M - A short textual representation of a month (three letters)
- n - A numeric representation of a month, without leading zeros (1 to 12)
- t - The number of days in the given month
- L - Whether it's a leap year (1 if it is a leap year, 0 otherwise)
- o - The ISO-8601 year number
- Y - A four digit representation of a year
- y - A two digit representation of a year
- a - Lowercase am or pm
- A - Uppercase AM or PM
- B - Swatch Internet time (000 to 999)
- g - 12-hour format of an hour (1 to 12)
- G - 24-hour format of an hour (0 to 23)
- h - 12-hour format of an hour (01 to 12)
- H - 24-hour format of an hour (00 to 23)
- i - Minutes with leading zeros (00 to 59)
- s - Seconds, with leading zeros (00 to 59)
- u - Microseconds (added in PHP 5.2.2)
- e - The timezone identifier (Examples: UTC, GMT, Atlantic/Azores)
- I (capital i) - Whether the date is in daylights savings time (1 if Daylight Savings Time, 0 otherwise)
- O - Difference to Greenwich time (GMT) in hours (Example: +0100)
- P - Difference to Greenwich time (GMT) in hours:minutes (added in PHP 5.1.3)
- T - Timezone abbreviations (Examples: EST, MDT)
- Z - Timezone offset in seconds. The offset for timezones west of UTC is negative (-43200 to 50400)
- c - The ISO-8601 date (e.g. 2013-05-05T16:34:42+00:00)
- r - The RFC 2822 formatted date (e.g. Fri, 12 Apr 2013 12:01:05 +0200)
- U - The seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)
Business Date Tag
It may be necessary to populate a date in the future in business days; omitting weekends and federal holidays from the calculation. A special tag was developed to be used in these cases.
For example if you include a cancellation form in your contract that your client can sign and submit to cancel service within 10 business days of the Signing Date of your agreement you would use the tag as displayed below to populate the date 10 business days in advance. Assume the sign date is 8/2/2016 using the tag as {BDATE:M d, Y || 10 ||{DATE}} will populate the date 10 business days form that date which would be "Aug 16, 2016" (adhering to the formatted codes we used within the tag itself "M d, Y").