Input date and return value

[rayted]

Hi guys,



Can anyone guide me on writing the SQL for:

[Please input date] and then the user adds the date in mm/dd/yyyy format and the value returned should be 28 (days) - the input (so I want to show the due date)

Thank you!

[ranman256]

dont write sql, make a query.
the query would look at a form with 2 dates; txtStartDate, txtEndDate

txtStartDate is where the user enters the date.
the txtEnd date formula = DateAdd("d",28,txtStartDate) '(or -28 if you want)

the query would be:
select * from table where DateFld between forms!myForm!txtStartDate and forms!myForm!txtEndDate

[rayted]

Hi Ranman

Thank you for your reply.

Do you mean create a basic form and using a 'text box' as part of the form? Or do I need something else for the user to input the date? and similarly what box and where do I input the formula? in the properties box?

thanks!