Skip to Content
0
Former Member
Mar 18, 2009 at 04:29 PM

Date Difference Query Syntax Formatted Search

70 Views

Hi Experts,

My client renders a service(warehousing of Cargo) on time and material basis,therefore the Quantity column of the AR Invoice represents the number of days the cargo was warehoused.

I want to create a formatted search with reference to a query on this field to help me compute the number of days automatically. The number of days is normally calculated by Subtracting the the Admission date(Serial Number Details Table "OSRI", field "InDate" from the document date of the invoice) from the AR invoice document date.

Considering that the Item is serial number managed, the item serial number will connect the Serial Number details table to the AR Invoice table.

Can anybody help me with the syntax of the query that will achieve the above for me.

Waiting to hear from you .

Thanks