C# Programming
07-06-2009, 10:02 AM
Hi.
I'm developing a small application in C# and I use MS ACCESS database.
Right now the application is 95% done and I'm stucked at a report.
I used MS Report Wizard to create and filter reports and I had no problem till now.
I have to filter a report by date so that it shows only the record from the curent date.
The probloblem is that I tried everything I know but it seams that The Query Wizard in C# does not allow me to use any function for filtering by date.
I used Today(), Now(), CurDate(), SysDate(). Date() but none of them worked.
I'm assuming that this has something to do with date format in VC# and MS ACCESS but I'm not sure.
Since I'm new to C# I considered MS Report Wizard to be a fast solution but I'm not so sure anymore.
Now I have 2 more days to finish the app and I can't find anything to help me solve thios problem.
Any idea or suggestion is much appreciated.
I'm developing a small application in C# and I use MS ACCESS database.
Right now the application is 95% done and I'm stucked at a report.
I used MS Report Wizard to create and filter reports and I had no problem till now.
I have to filter a report by date so that it shows only the record from the curent date.
The probloblem is that I tried everything I know but it seams that The Query Wizard in C# does not allow me to use any function for filtering by date.
I used Today(), Now(), CurDate(), SysDate(). Date() but none of them worked.
I'm assuming that this has something to do with date format in VC# and MS ACCESS but I'm not sure.
Since I'm new to C# I considered MS Report Wizard to be a fast solution but I'm not so sure anymore.
Now I have 2 more days to finish the app and I can't find anything to help me solve thios problem.
Any idea or suggestion is much appreciated.