I have two fields, one for Date and one for Time, I have joined them in a formula field as follows:
@DateTime
datetime(date({Detail.DateChangeDue}),time({Detail.TimeChangeDue}))
This is great, its showing 28-Feb-2008 17:00
This field shows previous and future dates and time. This report is to be run daily, but should only show records where the date is between Today 17:00 and tomorrow at 17:00
I really dont know how to do this, assume its something like "CurrentDate 17:00:00 in CurrentDate+1 17:00:00" but I have no idea.
Many thanks
UrbanHim
Crystal XI Report Writer
London
[small]What's the best cure for a hangover?... Heavy drinking the night before!![/small]
@DateTime
datetime(date({Detail.DateChangeDue}),time({Detail.TimeChangeDue}))
This is great, its showing 28-Feb-2008 17:00
This field shows previous and future dates and time. This report is to be run daily, but should only show records where the date is between Today 17:00 and tomorrow at 17:00
I really dont know how to do this, assume its something like "CurrentDate 17:00:00 in CurrentDate+1 17:00:00" but I have no idea.
Many thanks
UrbanHim
Crystal XI Report Writer
London
[small]What's the best cure for a hangover?... Heavy drinking the night before!![/small]