This content has been marked as final.
Show 3 replies
-
1. Re: How can I increment the date (format: 01/27/14) by 7?
kettan Jan 27, 2014 3:15 AM (in response to malou.puyod)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?
kettan Jan 27, 2014 6:02 AM (in response to malou.puyod)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.
-
3. Re: How can I increment the date (format: 01/27/14) by 7?
malou.puyod Jan 27, 2014 5:51 PM (in response to kettan)Thanks. Got it!