Skip to main content
Question

Add or subtract Period function in Report Designer


nhatnghetinh
Captain II
Forum|alt.badge.img+10

Hi ALL,

Is there any function to add or subtract Period in Report Designer without using text string concatenation?
+ Period is in the format 'mm-yyyy'
+ Example: ARTran.FinPeriodID = 05-2023
=> ARTran.FinPeriodID - 12 Periods = 06-2022
=> ARTran.FinPeriodID + 3 Periods = 08-2023

 

Best Regards,

NNT

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings