financial year

[#1]

please help me

my fiscal year is from 01.03. - 28.02.

in my table i have a coluimn with year and a column wit period 1 to 12

Can u explain me what i have to do to get for Period 1 the month march for period 2 month April

im able to make the date from These two files like period 1 Year 2014 = 01.01.2014 with makedate but i Need 01.03.2014

thanx

[agni_gold]

=

Date(MakeDate(2014,3,1),'DD-MM-YYYY')

[agni_gold]

=

Date(MakeDate(2014,A+2,1),'DD-MM-YYYY')

Here A is my period

[PrashantSangle]

Hi,

If you are able to create date field using makedate()

then for creating financial Year you need use

YearName(datefield,0,3)

Regards         

[Colin-Albert · Accepted solution]

Try this

Addmonths(makedate(financial_year, 2), period)

[jagan]

Hi,

Check this link for Fiscal Calendar generation

Fiscal and Standard Calendar generation

Regards,

Jagan.

[#7]

this is my script

Load Periode,

          geschäfstjahr,

     makedate(geschäfstjahr,Periode+2,1) as Date1,

   YearName(Date1,0,3),

KST,

Wert

From....qvd

error

concatenate

field not found     <Date1>

[jagan]

Hi,

Try like this

LOAD

*,

YearName(Date1,0,3) AS Year;,

Load Periode,

          geschäfstjahr,

     makedate(geschäfstjahr,Periode+2,1) as Date1,

KST,

Wert

From....qvd

Regards,

Jagan.

[#9]

thanx a lot

[Colin-Albert]

Load Periode,

          geschäfstjahr,

     addmonths(makedate(geschäfstjahr,2),  Periode) as Date1,

   YearName(Date1,0,3),

KST,

Wert

From ... Qvd