Skip to Content
0
Former Member
Jan 19, 2005 at 04:44 PM

How to get the current posting period

347 Views

Hi,

Is there any way to get the current posting period?

We have used the following query to get it...

SELECT T0.Code AS 'Period Code', T0.Name AS 'Period Name' FROM [dbo].[OFPR]

T0 where getdate() >= F_RefDate and getdate() <= T_Refdate FOR BROWSE

However, this query will not giving the correct output when the user changes the period to previous period. Is there any other way to get the default Posting period?

Thanks

Ajith