Last post Jan 04, 2006 06:22 PM by algocode
Dec 28, 2005 12:05 PM|Prashant S Akerkar|LINK
Added Entry/Enteries for the selected date range
26/12/2005 - 1/1/2006. Checked Successfully Inserting Record/s in the
TT_EntryLog Table. i.e Week Ending Date :
Problem : Entries Inserted in the Database not getting displayed in Time Entry Page
Thanks & Regards,
Dec 28, 2005 07:35 PM|flemdogg|LINK
I'm having the same issue. Anyone have a fix for this?
Dec 30, 2005 01:15 AM|algocode|LINK
Dec 30, 2005 02:38 AM|algocode|LINK
Convert(nvarchar, EntryDate, 1) >= Convert(nvarchar, @StartDate, 1)
Convert(nvarchar, EntryDate, 1) <= Convert(nvarchar, @EndDate, 1)
EntryDate >= Cast(@StartDate as smalldatetime)
EntryDate <= Cast(@EndDate as smalldatetime)
Dec 30, 2005 03:04 PM|emr0d|LINK
Jan 03, 2006 04:27 PM|algocode|LINK
I apologize profusely for the wrong suggestion. I found this solution somewhere on the internet with plenty of explanations but couldn't test it because I didn't have access to my database from where I was when I found information on this problem. I also
CONVERT(datetime,CONVERT(nvarchar,EntryDate, 1)+' 00:00:00 AM')
BETWEEN @StartDate AND @EndDate
but it didn't work either.
Jan 03, 2006 07:26 PM|algocode|LINK
OOPS! I was right.
The changes I posted were the correct ones, there were just deployed at the wrong place. They need to be deployed in the dbo.TT_ListTimeEntries stored procedure, using SQL Server Entreprise Manager.
Jan 03, 2006 08:48 PM|emr0d|LINK
Jan 04, 2006 06:22 PM|algocode|LINK