General discussion

Locked

select by date

By sziz ·
Tags: Off Topic
dear
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.Close
rs.Open "select * from SHEDUAL3 where prvstn='" & Mprvstn & "'and EffDate=#" & Mdate & "#"
hrc = rs.RecordCount
thankes

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| 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.

Back to After Hours Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums