ALTER PROCEDURE coglej.GetEventsForDate
@eventdate datetime,
@eventowner varchar (50)
AS 

IF eventdate is more than 2 weeks away
SELECT     dbo.events.event_date, dbo.locations.city, dbo.locations.state, dbo.locations.name, dbo.locations.address1, dbo.locations.address2, dbo.locations.zip, 
                      dbo.skus.sku_id, dbo.skus.event_type, dbo.skus.price, dbo.skus.slots_available
FROM         dbo.events INNER JOIN
                      dbo.locations ON dbo.events.location_id = dbo.locations.location_id INNER JOIN
                      dbo.skus ON dbo.events.sku_id = dbo.skus.sku_id
WHERE     (dbo.events.event_date = 'eventdate') AND (dbo.skus.owner = 'eventowner') AND (dbo.skus.price_type = 'Early')

ELSE evendate is less than 2 weeks away

SELECT     dbo.events.event_date, dbo.locations.city, dbo.locations.state, dbo.locations.name, dbo.locations.address1, dbo.locations.address2, dbo.locations.zip, 
                      dbo.skus.sku_id, dbo.skus.event_type, dbo.skus.price, dbo.skus.slots_available
FROM         dbo.events INNER JOIN
                      dbo.locations ON dbo.events.location_id = dbo.locations.location_id INNER JOIN
                      dbo.skus ON dbo.events.sku_id = dbo.skus.sku_id
WHERE     (dbo.events.event_date = 'eventdate') AND (dbo.skus.owner = 'eventowner') AND (dbo.skus.price_type = 'Regular')

quote:

---

Originally posted by Linok

Thanks alot!

I final question (hopefully).

When I run the SP in Access it gives me the following error: Syntax error converting datetime from character string.

This has me a little confusing because I'm only comparing datetime's to datetime's. Since I'm running the SP from within Access and just typing in the values, would that be what's causes the typecasting issue?

Thanks

---

If SomeDate >= Now + 14 Then
   something
Else
   something other
End If