Skip to main content
Question

Convert year and period parameters to yyyymm

  • August 7, 2024
  • 1 reply
  • 18 views

Forum|alt.badge.img+3

hello,

We have a business reporter with 2 parameters: year and period. We will use the scheduled reports option to schedule this report and enter context variables (e.g. #year#, #last month#).

using function parameters, we need to figure the year period (yyyymm) which will be used to filter on various report columns (e.g. last period, last year current period etc.). 

The issue is that if we enter year:2024 and period:7, how can we get business reporter to convert these 2 parameters to year-period value 202407 instead of 20247. 

Any suggestions? This is in Apps 10 (version 5.0.27). 

 

1 reply

Forum|alt.badge.img+3
  • Author
  • Do Gooder (Partner)
  • 3 replies
  • August 7, 2024

Found a way… See below.

Convert year to year string (to_char)

Convert period to period string (to_char)

lpad(periodstring, 2, 0)

concatenate year and lpad(periodstring,2,0)

2024 and period 7 will show up as 202407. 

 


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