Hi Dudes,
Front-End=VB.net (using DateTimePicker)
Back-End=MSAccess
--query written--
strSelport = "select * from inspection where insDate between #" & FormatDateTime(CDate(dtpFrom.Value), DateFormat.ShortDate) & "# and #" & FormatDateTime(CDate(dtpTo.Value), DateFormat.ShortDate) & "#"
when i input the date as '05/07/2008' to '19/12/2008', the retrieved result shows from '07/05/2008' to '19/12/2008'
If i change the date format in regional setting as dd/MMM/yyyy', then retrieved result is correct....
Is there any way so that without changing regional setting i can retireve correct result.
b'Rgds,
V'jay
Front-End=VB.net (using DateTimePicker)
Back-End=MSAccess
--query written--
strSelport = "select * from inspection where insDate between #" & FormatDateTime(CDate(dtpFrom.Value), DateFormat.ShortDate) & "# and #" & FormatDateTime(CDate(dtpTo.Value), DateFormat.ShortDate) & "#"
when i input the date as '05/07/2008' to '19/12/2008', the retrieved result shows from '07/05/2008' to '19/12/2008'
If i change the date format in regional setting as dd/MMM/yyyy', then retrieved result is correct....
Is there any way so that without changing regional setting i can retireve correct result.
b'Rgds,
V'jay