Date in bussines objects sql code

J

jetonbajramaj

Hi,

This is my problem

in my sql code i have this par of the code

and trn_dt = @variable('Enter date')

problem is that i want this automatically to be done by system for
current date
because this report must to be refreshed every 5 minutes.

example

and trn_dt = now()

the date format used is DD-MMM-YYYY

Can anyone help me.

Thanks
 
Top