coldfusion flash integration: I'm using the date/time dataType in my SQL Server DB. I have a grid that shows
the date of when an order was placed; right now, it displays like this: Oct 05
2005 00:00:00. How do I get my date to display like this: Oct 05 2005, without
showing the time in the grid?

Thanks

I am having the same issue. I am using flash remoting to return my result set.
If I post directly to the cfc and return a query result I can format the date
using mask="mm/dd/yy" just fine. ANyone have this happen to them and were you
able to find a solution. I am also having the same issue when trying to mask a
number format.

I have done this before (SQL Datetime in a grid). I have used the mask in the
cfgridcolomon. Here is a piece of some code that works for me:

<cfgridcolumn name="actiondate" header="Action Date" width="80" select="yes"
dataalign="center" mask="mm/dd/yy">

I hope this helps.

Hi there

I have used the same approach for the date format and it works fine - just
wondering what I need for time so as to get say 9 am and or 9 pm

I have the following but am only getting

<cfgridcolumn name="StartTime" header="Start Time" dataalign="left" mask="hh
tt">


I am just getting either say 21 or 9 etc

Would like to get say 9am or 9pm