Skip to main content
Question

Add or subtract Period function in Report Designer

  • August 30, 2024
  • 0 replies
  • 43 views

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

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