results for last 14 days (1 Viewer)

[bbwolff]

I'd like to get results for last x days

I'm trying to use this, but it doesn't filter the results

DoCmd.OpenForm "Overview", , , "oDate" > (Date - 14)

or more specificaly

DoCmd.OpenForm "Overview", , , "oOdd = '" & Me.cmbodd & "' and oDate" > (Date - 14)

i tried plenty of different variations with not much success

 

[Galaxiom]

DoCmd.OpenForm "Overview", , , "oDate >" & Format(Date - 14, "\#mm\/dd\/yyyy\#")

 

[MarkK]

Or . . .

DoCmd.OpenForm "Overview", , , "oDate > #" & Date - 14 & "#"

. . . but maybe you are seeing that a date requires "#" as delimiters.

 

[bbwolff]

thanks, first one works, second calls for a syntax error

 

[bbwolff]

I'm still having problems with dates

I can't write a code that would select all the records with the same date as is in a textbox

set rs= currentdb.openrecordset ("SELECT * FROM tblOp WHERE odate = #" & me.tdate & "#")

I tried a lot of variations (as I'm ashamed to admit I still can't really do it) but I'm getting either syntax error or not enough parameters error.

SELECT * from tblOp WHERE odate= #" & Format(datum, "dd-mmm-yyyy") & "# "
this code gets syntax error in date... odate = #17-maj-2016".

 

[Galaxiom]

Try reading my previous post again. Where did you get the idea of formatting the date as "dd-mmm-yyyy" ?

 

[bbwolff]

"select * from tbl where odatsa= " & Format(Me.txtDate, "\#mm\/dd\/yyyy\#"))

funny thing, it looks the same now, must have done something wrong