Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=
Date(MakeDate(2014,3,1),'DD-MM-YYYY')
=
Date(MakeDate(2014,A+2,1),'DD-MM-YYYY')
Here A is my period
Hi,
If you are able to create date field using makedate()
then for creating financial Year you need use
YearName(datefield,0,3)
Regards
Try this
Addmonths(makedate(financial_year, 2), period)
Hi,
Check this link for Fiscal Calendar generation
Fiscal and Standard Calendar generation
Regards,
Jagan.
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>
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.
thanx a lot
Load Periode,
geschäfstjahr,
addmonths(makedate(geschäfstjahr,2), Periode) as Date1,
YearName(Date1,0,3),
KST,
Wert
From ... Qvd