How to add date variables in DW and VC?
Formats
- MM/DD/YYYY and MM-DD-YYYY
- YYYY/MM/DD and YYYY-MM-DD
- M/D/YYYY and M-D-YYYY
- MM-YY and MM/YY
Opening in the Calendar
Click the date and the Calendar pop-up box appears. You can change the day but not month and year.
Obtaining the Year, Month, and Date
- To get year, month, and day, enter Number as Variable Type and Amount as Format.
- You will get the Year, Month, and Day. However, since the format for the Year is given as Amount, Year appears as a number. In Discovery Wizard, if you see a difference in day it is due to time zone difference.
Adding One Month
- Enter the formula for adding one month to a given date.
- You can see that one month is added to the date. In Discovery Wizard, you can see one day difference in the date due to the time zone difference.
- You can see that correct date is shown in Value Collaborator.
Adding Two Months
- Enter the formula for adding two months to a given date and let the day be the first of the month.
- You can see one day difference in the date in Discovery Wizard due to the time zone difference.
- You can see that in Value Collaborator two months are added to the date and the day is 1st of the month.
Adding One Year
- Enter the formula for adding one year to a given date.
- You can see the year changed in the Discovery Wizard. One day difference in the date is due to the time zone difference.
- You can see the year changed in Value Collaborator.
Adding No: of Days
- Enter the formula for adding to the days.
- In the Discovery Wizard, the exact days get added up.
- In Value Collaborator, the days get added up.
Subtracting Two Days
- Enter the formula for subtracting one date from the other. Enter Number for Variable Type and Amount for Format.
- The answer appears in Discovery Wizard but the one day difference is due to the time zone difference.
- The answer appears in Value Collaborator.
Today's Date
- Enter the formula for getting today's date.
- In Discovery Wizard, the date appears.
- In Value Collaborator, the date appears.