Rocky Smolin
rockysmolin at bchacc.com
Thu Sep 22 13:36:37 CDT 2011
Dear List: Because I'm old and can't remember (and the archives are down), I was told how to filter with dates so that if a user is using international dates it doesn't matter. The following code: If Nz(Forms!frmPOReport!txtGEPromisedDate) <> "" Then If Len(strSQL) <> 0 Then strSQL = strSQL & " AND " strSQL = strSQL & "fldPOPromisedDate >= #" & Forms!frmPOReport!txtGEPromisedDate & "# " End If If Nz(Forms!frmPOReport!txtLEPromisedDate) <> "" Then If Len(strSQL) <> 0 Then strSQL = strSQL & " AND " strSQL = strSQL & "fldPOPromisedDate <= #" & Forms!frmPOReport!txtLEPromisedDate & "# " strSQL eventually ends up in Me.Filter. Works good in the USA. :) Fails in Nicaragua. :( Was it CDate I was supposed to use? Sorry for the redux. TIA Rocky