Insert Day process into bex analyzer query.

Hi all,

Actually we need to create a query that show into a column the day when the query is execute, the query result will be use to create vía rscrm_bapi a flat file and the date have to be shown into a column. The problem as we see is that any of infocubes have a 0CALDAY as time characteristics just 0CALMONTH AND 0CALWEEK, I made some test using formula variable but it's dosen´t work, could you can give me any suggestion?

I appreciate all your help.

Egan.