Calculations for date cells
In Financials, certain cells have been created by Caseware to show date formats.
For example:
DATE1 |
clp13 |
Reads date for current year based on engagement profile. e.g. 31 December 2006 |
DATE2 |
itod(dmy(day(clp13),month(clp13), |
Reads date for prior year based on engagement profile. e.g. 31 December 2005 |
DATE3 |
itod(dmy(day(clp13),month(clp13), |
Reads date for second prior year based on engagement profile. e.g. 31 December 2004 |
YEAR |
year(clp62) |
Reads current year based on engagement profile. e.g. 2006 |
YEAR1 |
year(clp62)-1 |
Reads prior year based on engagement profile e.g. 2005 |
YEAR2 |
year(clp62)-2 |
Reads second prior year based on engagement profile e.g. 2004 |
YED |
iif (::ISFIRMLIB=1, cvdata("CQ100020_217"), |
Returns the year end date. e.g. 31 December 2006 |
A common request is what calculation should be used to just return the current year end and month without displaying the year in the format dd MMMM (31 December).
This can be achieved using the following calculations:
Year end Day and Month: dd MMMM | mkstr(day(clp13))+" "+monthstr(clp13) |
Year end Day and Month prior year: dd MMMM | mkstr(day(clp63))+" "+monthstr(clp63) |
Year end Day, Month and Year, current year: dd MMMM YYY | mkstr(day(clp13)) + space(1) + monthstr(clp13) + " " + mkstr(year(clp13)) |
Year end Day, Month and Year, prior year: dd MMMM YYY | mkstr(day(clp13)) + space(1) + monthstr(clp13) + " " + mkstr(year(clp13)-1) |
Year beginning Day, Month and Year, current year: dd MMMM YYY | mkstr(day(clp62)) + space(1) + monthstr(clp62) + " " +mkstr(year(clp62)) |
Year beginning Day, Month and Year, prior year: dd MMMM YYY | mkstr(day(clp62)) + space(1) + monthstr(clp62) + " " +mkstr(year(clp62)-1) |
- Related template: AccountsAdv IFRS, Charity/Academy, Group consolidation, Non-Corporate Accounts3, Pension Accounts3, FRS101/102/105 LLP
- Software platform: Working Papers 2018, Working Papers 2019, Working Papers 2020, Working Papers 2021, Working Papers 2022