Hi All...
Can someone point me in the right direction of what i am doing wrong please, because i have been spending most part of today trying to figure it out and as yet it has not dawned on me.
I am tring to select the number of open issues from a database for a given date and particular customer. I have set up 2 parameters, one for date and one for Customer.
The dates in the databases are stored in epoch format (as seconds) so a simple conversion has to be done to change the input date which is in the format dd/mm/yyyy to convert it into seconds. What i am trring to do is select data from 00:00:00 ogf the input date to 23:59:59 of the same date.
The record selection criteria formula is below:
TRKSL.X9 = 1 and
({TRKSL.X7} >= (DateDiff ("s",DateTime (1970,01,01,00,00,00),{?PP_BeginDate})) and
{TRKSL.X7} <= (DateDiff ("s",DateTime (1970,01,01,00,00,00),DateTimeValue({?PP_BeginDate}, Time(#23:59:59 pm#)))))
The X9 colum refers to an open issue.
When i run the report it gives me only one record for one particular date i enter. However when i choose the "Show SQL Query option" and then copy the query into Toad or some other SQL program it gives me 4 records, which is what i was expecting.
I can't figure out exactly where the code is failing in Crystal.
Does anyone have any ideas or tips/suggestions for working out where the problem lies.
THanks
IP Logged
