DateAdd Function Help

[Former Member]

Good Morning,

I have a report right now that displays all the appointment times for a doctor. I need to create a report that looks for appointments 2 days ahead of the current date. I.E. If i run the report on a monday, i will get wednesdays appointments.

I have tried going to my select expert and pick appointments.appt_date then picked formula and tried both

appointments.appt_date = 'currentdate' +2

and

appointments.appt_date =dateadd(u201Cdu201D, 2, currentdate)

The bottom formula works if i put it in the details and will return the correct date. But how do i select the records using this formula? Also my appointments field is formatted as 20081223. I suspect that maybe my select statement isnt working because the dates are in this format? If i right click that field and pick format field there isnt a date tab. Sorry to be such a noob, but I could really use some help on this.

Thanks

Ringrim

Edited by: Robert Ingrim on Dec 23, 2008 6:38 PM

[Former Member]

Sastry,

Thanks for your help. Am a bit confused as to where i put this formula. I created a new one called DT and then pasted what you suggested. When I throw that into the details section, it gives me the date 11/28/2008. Then i went to select expert and tried the second part but DT doesnt show up. Sorry I am thoroughly confused at this point.

Rob