topic Re: Date Conversion modules in Application Development and Automation Discussions

Date Conversion modules

Former Member — Tue, 29 Aug 2006 12:51:33 GMT

I want to convert calendar month to a fiscal period, calendar year to a fiscal year, ( vice versa given a fiscal period how to find calendar month and given fiscal year the calendar year).

Please note that in both cases I will have the fiscal variant as well.

Please Help

Regards

Re: Date Conversion modules

andreas_mann3 — Tue, 29 Aug 2006 12:59:55 GMT

hi,

1) FTI_FISCAL_YEAR_MONTH_GET

2) G_POSTING_DATE_OF_PERIOD_GET

Message was edited by: Andreas Mann

Re: Date Conversion modules

Former Member — Tue, 29 Aug 2006 14:18:20 GMT

It depends on how the fiscal periods are defined.

If the fiscal period begin the first day of the month and end the last day you could use the following fms...

DATE_TO_PERIOD_CONVERT -> given a date it returns the fiscal period...

PERIOD_DAY_DETERMINE -> given a fiscal period it returs start and end date.

(check OB37 for the Fiscal year variant)

If the fiscal period are defined across months (e.g. 2003.01 starts 23.09.2002 and ends 20.10.2002) It won't work...

Reward Helpful

Regards