I have a lobby element which uses year period as a parameter, is there a way to have the description show in the title, rather than just the year period.
e.g. if I enter ($YEAR_PERIOD$) in the title, it correctly shows 2020-07, but I’d like it to show January 2020.
Is there a way to use a SQL query in the title?
Is this any help? It converts ‘7’ to ‘July’
select TO_CHAR(TO_DATE(7, 'MM'), 'Month') from dual
Linda
Thanks PRODQ for your reply. I can’t seem to get it to accept any SQL in the title, unless there is a particular way to format it. Period 7 is also January rather than July, as it is Financial Year Jul-Jun, so the month option wouldn’t work.
You could add the date “conversion” to the source view as a custom field and then develop the lobby data source using the “cfv” view so you can incorporate the custom field OR add it as follows:
Hope this helps…
Linda
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.