[RESOLVED] I can't understand recordselectionformula

[tommygrayson]

Hi guys! This is my first time to use a recordselectionformula on Crystal Reports 10. I get this error that the date-time is required and it points me to this code:


AnAccountReport.RecordSelectionFormula = "{Account_Code.Account_Code} >= '" & Trim(Text1.Text) & "' and" _
& "{Account_Code.Account_Code} <= '" & Trim(Text2.Text) & "' and " _
& "{GL_Table.Date} >= '" & Format(DTPicker1.Value, "MM/dd/yyyy hh:mm:ss") & "' and " _
& "{GL_Table.Date} <= '" & Format(DTPicker2.Value, "MM/dd/yyyy hh:mm:ss") & "' and " _
& "{GL_Table.Date} >= DateTime (2004, 08, 1,00, 00, 00) " _
& "and " _
& "if {GL_Table.Date} = '" & Format(DTPicker1.Value, "MM/dd/yyyy hh:mm:ss") & "' then " _
& "{GL_Table.Entry_Type} <> 'BB' " _
& "Else " _
& "{GL_Table.Entry_Type} <> ''"


Is there something wrong?

[ganeshmoorthy]

& "{GL_Table.Date} >= '" & Format(DTPicker1.Value, "MM/dd/yyyy hh:mm:ss") & "' and " _
& "{GL_Table.Date} <= '" & Format(DTPicker2.Value, "MM/dd/yyyy hh:mm:ss") & "' and " _
& "{GL_Table.Date} >= DateTime (2004, 08, 1,00, 00, 00) " _


why are you checking the date for 3 times....

use Date as [Date]
{GL_Table.[Date]}

[ganeshmoorthy]

is your GL_Table.[Date] is having the same format of "MM/dd/yyyy hh:mm:ss"

[tommygrayson]

& "{GL_Table.Date} >= '" & Format(DTPicker1.Value, "MM/dd/yyyy hh:mm:ss") & "' and " _
& "{GL_Table.Date} <= '" & Format(DTPicker2.Value, "MM/dd/yyyy hh:mm:ss") & "' and " _
& "{GL_Table.Date} >= DateTime (2004, 08, 1,00, 00, 00) " _


why are you checking the date for 3 times....

use Date as [Date]
{GL_Table.[Date]}

The first date is the starting date or from date.
The second date is the to date.
The third date is the filtering date.

[tommygrayson]

is your GL_Table.[Date] is having the same format of "MM/dd/yyyy hh:mm:ss"

Well its a datetime variable and its format is MM/dd/yyyy

[ganeshmoorthy]

then why are you passing the date with time...
just send MM/dd/yyyy

[tommygrayson]

then why are you passing the date with time...
just send MM/dd/yyyy

Well I also did that but I still have the same error.

[tommygrayson]

Now I know why I haven't managed to move on. I must add a DATETIME function in the recordselectionformula.

Thanks anyway.

[Hack]

Moved to reporting section.