Metric expression

[gsai]

Hi all,
i got to have this expression (TRUNC(sysdate)-Drop_Date) in a metric where Drop_date is an attribute.How do i do this?

i'am new to microstrategy

let me know

thanks

 

[iolaper]

APPLYSIMPLE("(TRUNC(sysdate)-#0", DATE)

DATE is not Drop_Date but the form in the attribute that contains your date.

It's been a while since I used ApplySimple, so if I am wrong someone please correct me.

Thanks
iolaper