Is the function for getting system date for BRIO operating within
Redbrick DB is:

getDate();

and for Oracle is:

SysDate();


I am trying to run a report (operating in Redbrick DB) which
captures PAST THREE MONTHS. This report has to run EVERY WEEK.

So my logic is to find out TODAY's DATE and MINUS 3 months.

Also, what is the syntax or formula to MINUS 3 months???

sysDate() - 90 ?

please assist.

Thanks.

Anton

Oracle,

select SYSDATE - Interval '3' Month from dual;

OR

select add_months(sysdate, -3) from dual;

thanks.

but can I get the current date without using the dual table, if it's on oracle?

how about redbrick?

the db i'm querying on is on redbrick.

U Can get today date in rebrick using
current_date.


Thanks,
Praveen.

yep. thanks!

I have similar requirment but inmycase i just need month and year in the format MMYYYY. that is for curent date - 3month