Data2.RecordSource = "Select format(audit.date_audit,'dd - mm - yyyy') from audit" data2.refresh var_temp = Data2.RecordSource.Fields("date_audit")
Data2.RecordSource = "Select audit.date_audit, sujet_audit from audit where format(audit.date_audit,'dd - mm - yyyy') > #" & Format(DTPicker1.Value - 1, "dd - mm - yyyy ") & "# and format(audit.date_audit,'dd - mm - yyyy') < #" & Format(DTPicker1.Value + 1, "dd - mm - yyyy ") & "# ;"
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionData2.RecordSource "Select audit.date_audit,sujet_audit from audit where format(audit.date_audit,'dd-mm-yyyy') format(cdate('" & DTPicker1.Value & "'),'dd-mm-yyyy')"