BI Publisher (MOSC)

MOSC Banner

add element by expression : how is it possible to add days to date parameter

edited Feb 1, 2013 3:43AM in BI Publisher (MOSC) 10 commentsAnswered
HI,

in data model  "add element by expression"

i would like to create an expression like :  "week  from  04/02/2013 to 08/02/2013"

my date parameter is DAT_PARAM  and it's a date and its format is DD/MM/YYYY

I tries this but without result

CONCAT('Week from  ',  CONCAT( FORMAT_DATE(DAT_PARAM,'dd/MM/yyyy'),  CONCAT('  to  ', FORMAT_DATE(DAT_PARAM + 4,'dd/MM/yyyy'))))

i have searched on web and in oracle documentation but no example

this expression return : week from 04/02/2013 to 04/02/2013

DAT_PARAM+4 is unknow

Is it possible ??

regards


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center