1 of 1 people found this helpful
This 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
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.
Thanks. Got it!