I am putting together a schedule query for receipt of files.
When the file is received I need to query the schedule table for [duedate].
If the current date is between [earlydays] and [latedays] I want to time date tag the
[ReceivedDate] associated with the [duedate] (this weeks file will be received up to -3days early, on time, or up to+3 days late)
Are there Any SQL querys out there that will do pieces of this?
Is there a preferred way to approach this?
Thanks,
D. Starr
When the file is received I need to query the schedule table for [duedate].
If the current date is between [earlydays] and [latedays] I want to time date tag the
[ReceivedDate] associated with the [duedate] (this weeks file will be received up to -3days early, on time, or up to+3 days late)
Are there Any SQL querys out there that will do pieces of this?
Is there a preferred way to approach this?
Thanks,
D. Starr
