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

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...