Start date and Completion date - do I need 2 calendars?

[josephinetedesc]

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

[zhadrakas · Accepted solution]

yes you can do this. check this:

Handling Multiple Calendars.qvw

Canonical Date

or you can use Common Date Dimension and Shared Calenders:

Tutorial - Using Common Date Dimensions and Shared Calendars

[josephinetedesc]

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.

[zhadrakas]

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

[nagarjuna_kotha]

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

[josephinetedesc]

thank you

Jo