Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
in my application I need a [start date] which is rounded up into months weeks etc and a [completion date] which is rounded up into months week etc.
I am thinking something along the lines of:
load
month(startDate) as StartMonth,
year(startDate) as StartYear,
month(endDate) as EndMonth,
year(endDate) as EndYear
whilst this is nice and simple - the problem will come when someone will want financial years quarter etc.
when that happens will I need to have 2 calendars - one for Start Dates and one for Completion Dates? I have seen Michael Tarallo's script for the use of Calendar scripts - but I am not sure how to apply it for this situation.
Thank you
Jo Tedesco
yes you can do this. check this:
Handling Multiple Calendars.qvw
or you can use Common Date Dimension and Shared Calenders:
Tutorial - Using Common Date Dimensions and Shared Calendars
yes you can do this. check this:
Handling Multiple Calendars.qvw
or you can use Common Date Dimension and Shared Calenders:
Tutorial - Using Common Date Dimensions and Shared Calendars
I think it will be easier if it stick to 2 calendars ... might be easier for users too!
Si I suppose I used Michael's script twice and be careful not to duplicate variable names
Thank you Tim.
For just two Dates its easier to use two seperate calenders. Just give them a different prefix or Suffix in field names.
Dont Forget to mark this question as answered.
regards
tim
if you don't want two calender's ,Create one unlined calendar , By using that you can control those in front end
I hope this may helps you
-Nagarjun
thank you
Jo