Attribute | Description (where applicable) |
Cash Flow Date | Represents the date for when the cash flow occurs |
Current Month Flag | Represents a flag that is set to 1 if the date represents the current month. Else the value is 0. |
Current Year Flag | Represents a flag that is set to 1 if the date represents the current year. Else the value is 0. |
Date | Represents the date as YYYY-MM-DD |
ID | Represents the date as YYYY-MM-DD |
ISO Week | Represents the ISO week number |
Last 12 Months Flag | Represents a flag that is set to 1 if the date represents previous 12 months. Else the value is 0. |
Last 24 Months Flag | Represents a flag that is set to 1 if the date represents previous 24 months. Else the value is 0. |
Month | Represents the date as month with three capital letters (JAN, FEB, MAR, …) |
Month No | Represents the date as month as number (1, 2, 3, …) |
Month String | Represents the date as month name (January, February, March, …) |
Previous Month Flag | Represents a flag that is set to 1 if the date represents the previous month. Else the value is 0. |
Previous Year Flag | Represents a flag that is set to 1 if the date represents the previous year. Else the value is 0. |
Quarter | Build as "Q" + "Quarter No" (Q1, Q2, Q3 or Q4) |
Quarter No | Quarter as number (1, 2, 3 or 4) |
Reporting Day of Month | Day of Month |
Week | Build as "W" + "ISO WEEK" (W1, W2, W3, …) |
Weekday No | Represents the weekday number |
Weekday String | Represents the name of the day (in the week) |
Year | Represents the year using four digits |
Year (Week based) | Represents the ISO year |
YearMonth | Represents the year and month using six digits |