Date value won't work in xl vb code

[BradleyS]

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'):

Please Login or Register  to view this content.

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 variable

All I have done is added the variable: Dim sDate As String sDate = 20131010

..And entered it in the code: WHERE (slotapp.slotdate='sDate')

Please Login or Register  to view this content.

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?

[FDibbins]

My VBA is poor at best, so I have no idea if this is relevant here, but excel uses 5-digit numbers for dates, even though it looks like a "real" date. So 10/12/2013 is actually 41559

[BradleyS]

Was finally presented with the answer:

Please Login or Register  to view this content.

Thank you anyway