thanks for the examples..
by backend.. i meant the sql.. i consider front end my display..
as for the code.. i am populating a grid via flash remoting.
<cfgridcolumn name="feedDate" header="Feed Date" mask="EEEE, MMM. D,
YYYY at H:NN A"/>
that is all there is...
On 10/24/05, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
> Well it is still front end really. Alan doesn't mean insert the date into
> the database already formatted in any special way; He means SELECT it in the
> desired format so you don't need to format it anywhere else.
>
> In MySql for example...
>
> SELECT DATE_FORMAT(DateField, '%W, %M %D, %Y');
>
> Would give you the date formatted like this straight from your query and all
> you'd need to do was output it... 'Sunday, October 24th, 2005'
>
> You could use datepart() or convert() to get 'basically' the same thing from
> SQL Server (I'm not sure SQL server has anything for Nth day though)
>
> Believe it or not, even MS Access comes equipped with some date functions
> :^O
>
> That's probably enough to fix you up but if you have any trouble just let us
> know the date/time format you are looking for and what database you are
> using.
>
> Ps... In CF, the mask is the last option in the function like...
>
> Dateformat(mydate, "mm dd yyyy")
>
> And not the first like...
>
> Dateformat("mm dd yyyy", mydate)
>
> When I started writing .NET apps I was very used to CF's XxxxxFormat()
> functions where the mask was always last. The mask comes first in VB's date
> formatter and when I put it last, the mask was actually displayed like
> you're descriing.
>
> I THINK CF would throw an error if it were backwards but it's worth
> checking. Just seems very odd that it displays the mask.
>
> You might also consider posting the bit of code that is displaying the mask
> so everyone can take a look.
>
> ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
>
>
> -----Original Message-----
> From: Jean-Baptiste Emanuel Zorg [mailto:[EMAIL PROTECTED]
> Sent: Sunday, October 23, 2005 11:32 PM
> To: CF-Talk
> Subject: Re: formatting a date in cfgrid
>
> it's just a regular date/time field always figured i could do it on
> the front end somehow.. i'll give that a lookig into though.. thanks
>
> On 10/23/05, Alan Rother <[EMAIL PROTECTED]> wrote:
> > This is just totally off the cuff here...
> > But if you can't get CF to do it right off, you could have your DB do it.
> > Just apply a date mask to it in the query. Most DB systems allow you to do
> > this.
> > HTH
> > Alan Rother
> > Macromedia Certified Advanced ColdFusion MX 7 Developer
> >
> > On 10/23/05, Jean-Baptiste Emanuel Zorg <[EMAIL PROTECTED]> wrote:
> > >
> > > i have a date that is populating a field in a grid like this:
> > > Tue Oct 18 21:25:48 GMT-0400 2005
> > >
> > > i have attempted to use mask="MMMM D, YYYY"
> > >
> > > but all it does is output the mask to the field.. any ideas how to mask
> > > this?
> > >
> > > thanks
> > >
> > >
> >
> >
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222022
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
