flexgrid

how can i change the format of mshflexgrid column
e.g i want the format column 3 to be mm/dd/yyyy

Quote:

---

.g i want the format column 3 to be mm/dd/yyyy

---

date always come in the mm/dd/yyyy format in the grid

i am using sql server 2000 bound to the grid
the column returns a dd/mm/yyyy hh:mm:ss

convert date into mm/dd/yyyy format and add in the grid

the format of the date in the database is in mm/dd/yyyy but when showed int the grid it returns dd/mm/yyyy hh:mm:ss format... the field i use is datetime datatype

which grid u r using

hierarchial flexgrid

Can't you format the date field to how you want it in the SQL statement ?
That way you don't have to worry what the flexgrid does.

can you use function format("mm/dd/yyyy")