Start and end date ???
The graph is displayed but there are no bars displayed. The tootlip only says "undefined".
I am connecting to a MSAccess database. The code looks like this:
Set WADWCStats_cmd = Server.CreateObject ("ADODB.Command")
WADWCStats_cmd.ActiveConnection = MM_diagramm9_STRING
WADWCStats_cmd.CommandText = "SELECT Stats_Date AS XLABEL, Stats_Date AS YVALUE FROM Stats WHERE Stats_Date >= #07-July-2010# AND Stats_Date <= #14-July-2010#"
WADWCStats_cmd.Prepared = true
Is there any SQL Date Problem using VB and MSAccess?
Can the dates also be set dynamic? eg. the customer choose dates with a datepicker or they are forwarded through input fields?
Thanks a lot, please be patient I am new to this all!