Skip to Content
Former Member
Jul 24, 2007 at 10:16 PM

SQL server ActivityMonth to fiscal year and Fiscalperiod


Hi All,

I am working on BI 7.0. we are getting data from Sql server Activitymonth( data type Int4 , length 4, external length 11) yyyyMM format. I need to map this to fiscalyear, fiscalperiod, fiscal year variant.I took variant as constatnt.I unable to get the correct format for year and fiscal period.Can any one help on this? If routines solves this issue,please send me the code.

Thanks in advance