Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am working on a report in which the year needs to start in September.
So September needs to be the first month in the year, and week 1 needs to be the first week in September (in 2012 for example, week 1 started on 03/09/12 ).
Any year to date calculations would need to take this into account too. For example, if I was putting together a chart to show orders placed YTD, this would need to run on a September - August year.
I'm hoping this may be an easy question to fix, but I currently have no idea where to start so any help would be greatly appreciated!
Thanks,
Danielle
hi
try this
YearName(datefield,0,7) as new_year
then year start with september as first month
Danielle
I suggest that in your script you create a month sequence number field, something like
LOAD ....
Year(TranDate) * 12 + Month(TranDate) As MonthSequence
...
And sort by the month sequence number
Hope that helps
Jonathan
I already use october, try to use to diferent dates, the calendar one and fiscal, so when you load your data transform it.
Load...Inv_Date, Date(AddMonths(Inv_Date,4)) as Fiscal_Inv_Date...
hi
just creat a new fiscal date like this
addmonths(date,4) as fiscal date
which will show as jan as your 1st month (but it is fiscal)
do all transforamtion to this fiscal date
Hope this helps
Thanks
Hi All,
Many thanks for your help so far!
I have tried out the YearName suggestion, and although this does successfully align the months to a September-starting year, it doesn't align the week numbers, so week 1 is still from the end of December / beginning of January.
Do you know how I would align the week numbers too?
Thanks again,
Danielle
You have to transforms all dates you are using...