Date substrection at VC output

[Former Member]

Dear Friends,

I want to do date substrection at VC.

current date MINUS date coming from bex query(its a standard keyfigure date in bex).

I tried NOW() - avilable date(text field), but we can use - for only numreic field.

want date substrection in no. of days.

Please suugest what to do.

regards,

dushyant.

[Former Member]

Hi ,

Ahmed is currect use that formula.

Regards,

Govindu

[Former Member]

DUSHYANT,

Try this Expression.

DSUB(NOW(),@CREATE_DATE,’D’)

Regards,

Ahmed Salah