Help with Query designer

[#1]

Dear  Experts
How can I achieve this in Query designer
I have many restricted key firures which holds date values which are as follows .

My requirement is to substract these key figures to get number of days the ticket was in particular status  as follows
FORMULA 1= Transaction date - Keys recd by FM  

Eg (01-01-2012 - 05-01-2012 = 5 days )
FORMULA 2= Key Rec. by FM - (FM Inspection Completed(if it has value) else it should be substrated
by "Transferred to Tenant Account " if blank then substract with "No Payment Due")

Thanks and Regards .

[Former Member]

Hi Mohammed,

In addition to what AL has already said, go through the below links for better understanding.

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/23/17f13a2f160f28e10000000a114084/frameset.htm

Regards,

Sujit.

[mohd_abdullah]

Hey Sujit

Thanks man !!

Regards .