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]

Hi Robert,

It is because the field you have in database is not a date field. It is a numberic field. Write the following formula and check your current date against this formula

Formula @dt

-

---

numbervar dd;

Numbervar mm;

numbervar yy;

dd:=tonumber(right(totext(20081228,"##"),2));

mm:=tonumber(mid(totext(20081128,"##"),5,2));

yy:=tonumber(left(totext(20081228,"##"),4));

cdate(yy,mm,dd)

--

Now in record selection you check like @dt = dateadd('d'm+2,currentdate)

This will get you the results.

Thanks,

Sastry