Topic: Request in basis by date at sight Excel
Question such... On sheet Excel in Cells (1, 1) there is a digit. For example, 4.
m = Sheets ("List1").Cells (1, 1).Value
In basis there are the conditional dates with different days, but with the necessary number of month with "mask" of 4/1/0000 - type, so...
How to write request, to draw out the conditional values r under number 4?
SQLr = "SELECT r FROM RRR where date = m"
I can not understand how to "equate" 4 to xx.04.xxxx and on the basis of it to write request.