After Hours

General discussion


select by date

By sziz ·
Tags: Off Topic
I have problem if date 01/11/2014 in data records return =0 their are 2 records avl see my cod
Mprvstn = rs3!PRVSTN
Mdate = Format(rs3!EffDate, "dd-mm-yyyy")
rs.Open "select * from SHEDUAL3 where prvstn='" & Mprvstn & "'and EffDate=#" & Mdate & "#"
hrc = rs.RecordCount

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

language and metalanguage

by john.a.wills In reply to select by date

Your metalanguage is English, but so carelessly written that I do not know what you are talking about. I do not recognize your programming language, although it appears to be quoting SQL. Furthermore, this should be posted in the Questions Forum, not Around the Watercooler.

Related Discussions

Related Forums