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:
0