You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Prompt - Default Programmatically setting date

Summary:

When adding in an accounting period, I'm not able to programmatically set a date with the format YYYY-MM. I've tried a few different things but I can't seem to make it work.

EX: For today's date (02/05/2025), I would like the default to set like the below image


Code Snippet (add any code snippets that support your topic, if applicable):

I've tried all of these but none of them seemed to give me what I wanted

select (@{system.currentTime}[YYYY-MM]) FROM "General Ledger - Transactional Balances Real Time"

select (@{system.currentTime}[YYYY] || "02") + FROM "General Ledger - Transactional Balances Real Time"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!