Financial Quarter

[joeybird]

hiya

I am using the following in my load script using Date_Received... in order to get my month, year ect fields

Calendar: DECLARE FIELD DEFINITION TAGGED '$date' Parameters first_month_of_year = 1 Fields

     Year($1) As Year Tagged '$year',

     Month($1) as Month Tagged '$month',

     Date($1) as Date Tagged ('$date', '$day'),

     Week($1) as Week Tagged '$week',

     Weekday($1) as Weekday Tagged '$weekday',

     DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric');

DERIVE FIELDS FROM FIELDS [Date_Received] USING Calendar;

how do I amend the code / add code above to get financial quarters please?

e.g Q1 = Jan to March

then how do I get financial year ....April 1st 2012 to March 31st of e.g. 2013

Please help

Kind Regards

Joeybird

[joeybird]

Hiya

got a major problem, since this code gets added to the sorting, it crashes the app and program.

it saves and works fine, when you create the dynamic graph. you go out of the app fully and go back in and the moment it goes to the sheet with the graph with the code below, it crashes.

I have created a new sheet from scratch, test again from scratch 

you add the code

if (getselectedcount([OrderDate.Calendar.FiscalYear])>0, [OrderDate.Calendar.FiscalMonthNumber], [OrderDate.Calendar.Month])

note:OrderDate is changed for my field

save ..use sheet all works fine, exit the app and go back in, the moment you get to the sheet with the graph in, it crashes the program

help please

kind regards

joeybird

[JonnyPoole]

could you share the app ? i do not get this behaviour myself.  I could share my sample too if it would help.

ps:  i'm using version 1.1

[joeybird]

Hiya

if (getselectedcount([OrderDate.Calendar.FiscalYear])>0, [OrderDate.Calendar.Year], [OrderDate.Calendar.Month]);

I accidently renamed one of my fields wrong in the middle...

sorry least we found an error and how to avoid it if it happens again xx

Kind Regards

Joeybird