Well it is still front end really. Alan doesnt 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:222009
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
