i am facing issue with record selection kindly help Error :
Error in File Summary 12360_7252_{17B9B96A-5843-4F76-92DB-502870DC5E67}.rpt: Error in formula Record_Selection: '{datamaster1.PaymentStatus}='SUCCESS' and {datamaster1.paymentdate}>=#2023-12-01# and {datamaster1.paymentdate}<=#2024-03-06#' A date-time is required here. Details: errorKind |
|
|
My Selection Formula:
"{datamaster1.PaymentStatus}='SUCCESS' and {datamaster1.paymentdate}>=#" & Format(FromDate, "yyyy-MM-dd") & "# and {datamaster1.paymentdate}<=#" & Format(ToDate, "yyyy-MM-dd") & "#"