flexgrid

[mikee_phil]

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

[shakti5385]

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

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

[mikee_phil]

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

[shakti5385]

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

[mikee_phil]

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

[shakti5385]

which grid u r using

[mikee_phil]

hierarchial flexgrid

[TheBionicOrange]

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.

[shukla]

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