end dates and start dates

[draacor]

I think i might be confusing myself but i have a command that looks like the following:
call_req.open_date < DATEDIFF(second, '1/1/1970',
{?02EndDate}+1) + (DATEDIFF(second, getutcdate(), GETDATE()) - DATEDIFF(second, getutcdate(), GETDATE()) * 2)

I do the {?02EndDate}+1) in order to get the full 24 day. Because i have this in my sql command then when i create formulas like the following in cr:

if {tickets.type} = 'I' and {tickets.open_date} >={?01StartDate} and {tickets.open_date} <= ({?02EndDate})
then 1
else 0

Do i need to put {?02EndDate}+1) in the formula as well? and if i dont do i put a <= or just a <.

 

[Madawc]

I'm unclear what you're after. The second formula would be better done as

{tickets.type} = 'I' and {tickets.open_date} >={?01StartDate} and {tickets.open_date} <= {?02EndDate}

Display on the same detail line as unselected data and it will show True or False, you'll see how it works.

If your dates include time you could lose this using Date({?02EndDate})



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10