-
1. Re: How can I increment the date (format: 01/27/14) by 7?
1 of 1 people found this helpfulThis calculations adds 7 days to the date:
.
date(dateadd('day', 7, [date])).
The reason I also used DATE was to convert it from DATETIME to DATE and thus save time in formatting it without time.
.
Instead of a string calculation, you could probably just format the date using the format mm"/"dd"/"yy :
Workbook Version: 8.1
-
2. Re: How can I increment the date (format: 01/27/14) by 7?
My x-axis is Date which has a format mentioned above BUT my problem is the dates should increment by 7 in which start date is always every Monday. How can I do this?
I think this is what you need:
Right-click Axis (for date) > Tick Marks > Fixed
Every 1 Weeks
Tick Origin 27-01-2014
I think your date axis needs to be continuous.
-
