Link to home
Start Free TrialLog in
Avatar of peterdevadoss
peterdevadoss

asked on

A date-time is required here. Crystal Report

I am passing the record selection forluma using the following code:
 report.DataDefinition.RecordSelectionFormula =
"{trans_dtl_conso.transaction_date}='" & Format(dtpFrom.Value, "MM-d-yyyy")  & "'"

Following error message appears:
A date-time is required here.
Error in File ...report file name dot rpt;
Error in formula <Record_Selection>.
'{trans_dtl_conso.transaction_date}='03-1-2006'
A date-time is required here.

datastruce of transaction_date is datetime in sqlserver.
I want to validate only the date.
ASKER CERTIFIED SOLUTION
Avatar of g_johnson
g_johnson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial