Tuesday, March 22, 2022

Get Fiscal year from Current Date in Crystal Report

 IF Month ( CurrentDate ) <= 6

THEN ToText( Year ( CurrentDate ) - 1, 0, "" ) + '/' + ToText( Year ( CurrentDate ), 0, "" )

ELSE ToText( Year ( CurrentDate ), 0, "" ) + '/' + ToText( Year ( CurrentDate ) + 1, 0, "" )

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/