I have been struggling with this for over a week now and just can't understand why I can't get the date section of code to work.
I'm using a data source and trying to enter a date range
This code works fine as it uses a predefined date range i.e. WHERE (slotapp.slotdate='20131010'):
I would like to use a cell in xl that I can enter a date, so to try and get this code to work I am first using a variable instead of a cell, but it doesn't recognise the date in the variablePlease Login or Register to view this content.
All I have done is added the variable: Dim sDate As String sDate = 20131010
..And entered it in the code: WHERE (slotapp.slotdate='sDate')
Does anybody know what I am doing wrong or why it won't work and what it is I need to do to get it to work?Please Login or Register to view this content.
Bookmarks