Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to create a calendar so that i nees to see the year as
Year |
---|
2013-2014 |
2014-2015 |
2015-2016 |
and so on. please could anyone help me.
Thanks.
Hi.
Load datefield, Year(datefield)&'-'&Year(datefield)+1 as Year from urtable;
Regards,
Kabilan K.
Hi,
what it means and if I use like this will it take year as 2013-2014,2014-2015,2015-2016 and so on.
YearName
(Date,0,7) AS FiscalYear