From to period is not working in OTBI report

Question

When i am trying to add a parameter, for budget period name , i am using between in the prompts but it's not giving the from to period.

Sometimes it's giving error and sometimes its just giving based on first letter (January June July if from jan to July).

If anyone knwos how to make the from to working.

Thanks in advance

Nathan CCC · Answer

Hi Omran,

Period name is a string not time. You could  perhaps change it to a prompt on a date like where "Period Start Date" or "Period End Date" between X and Y?

The decision on what period of time a period name represents using what naming convention was a choice made by your application implementation consultant. Your general ledger may be setup with any periods of time such as 7 day sun-mon weeks periods like in a 445 months calendar or most likely a year of 12 calendar months with 28-31 days maybe with a 13th adjustment period.

So on a string column between will work I think based on the alphabet numeric of the text in your period names. So this will not work as time unless perhaps your period names are in a format like international organization for standards format "yyyy-mm". But your period names are likely Mon-YY like "Dec-99".