I need to format text from two textboxes to use as DateTime type to filter in a DB Query. In other words, I need to pass the text date-like formatted to add it to the SELECT command to filter registries in the range of dates. Thanks in advance for any help whatsoever!!




MAKO - "El super simio"

__________________
MAKO - \"El super simio\"

All depends on what Database your using to store data.?
You nedd to convert the text box value to datetime format first .

For Ex:
DateTime fromdate = Convert.ToDateTime(txtStartDate.Text);

Hope this will solve your problem to filter the data.



Vivek Shah

Yes, it kinda helps a lot, but I tried this already and the datetime result is in the wrong format MM/dd/yyyy and I need the datetime value in format dd/MM/yyyy. Now there is an overload of the Convert.ToDateTime() Method that takes an IFormatProvider object. I don´t know how to use that overload, do you?

Thanks,

:)

MAKO - "El super simio"

You can do one thing that

Ex:

DateTime fromdate = Convert.ToDateTime(txtStartDate.Text);

DateTime fromNew = fromdate.ToString("dd/mm/yyyy");

You will ge the date format in dd/mm/yyyy format in the variable fromNew.

Hope this will solve your problem.

Good Luck

Vivek Shah

To give user more ease we generally use three combobox, 1 for date part, 2nd for month and 3rd for year to chose.This solve many issues.

Bijgupt

Thanks a lot, guys! Your postings were of much help!

I took the string from the textboxes and converted it to datetime datatype inside a function that returns that datetime variable as a string with dd/MM/yyyy format. Just as vivek shah showed me. Thanks, Vivek!

You Rock, dudes!!



MAKO - "El super simio"