Query for date greater than 6 weeks

  • Thread starter Thread starter JackieMottram
  • Start date Start date
J

JackieMottram

Guest
I am trying to create a query in a database based on getting refunds off organisations that have been overpaid by us. We have up to 3 request dates for the refunds. These request dates have to be 6 weeks apart. I want to run a query that shows me that it is 6 weeks after the previous request date and I need to follow up on payment. This may sound easy, but I have no idea what to do. Any suggestions?
 
In the query you can use the DateAdd() function to add 6 weeks and 12 weeks to the [First Request] field e.g.

SELECT [OrganisationID], [First Request],
DateAdd("ww",6,[First Request]) AS [Second Request],
DateAdd("ww",12,[First Request]) AS [Third Request]
FROM TableName;
 
This expression will give the date six weeks ahead.

DateAdd("d", 42, OriginalDate)
 

Users who are viewing this thread

Back
Top Bottom