Date() question?

"David Powers" <david@example.com> wrote in message
news:ft82eu$704$1@forums.macromedia.com...
> Murray *ACE* wrote:
>> The timing is not good for me this year! 8( My daughter's HS graduation
>> is on the 6th of June, and I wouldn't miss a moment of it.
>
> I hope you don't do your TODCon trick of falling asleep. :-p

I'll try an uphold that honor at TODCON for him :)

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:ft7nc3$p6c$1@forums.macromedia.com...
> Hunter:
>
> The timing is not good for me this year! 8( My daughter's HS graduation
> is on the 6th of June, and I wouldn't miss a moment of it.

as well you shouldn't! I do hope the graduation is great for her!

Murray *ACE* wrote:
> The timing is not good for me this year! 8( My daughter's HS graduation
> is on the 6th of June, and I wouldn't miss a moment of it.

I hope you don't do your TODCon trick of falling asleep. :-p

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

Hunter:

The timing is not good for me this year! 8( My daughter's HS graduation is
on the 6th of June, and I wouldn't miss a moment of it.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Hunter Elliott" <nospam@gatewaycity.com> wrote in message
news:ft5c5f$5p5$1@forums.macromedia.com...
>
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:ft3ld5$74e$1@forums.macromedia.com...
>> Good luck!
>
> LOL! With this crowd at my work, I definitely need luck! BTW, are you
> going to TODCON again this year, Murray?
>

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:ft3ld5$74e$1@forums.macromedia.com...
> Good luck!

LOL! With this crowd at my work, I definitely need luck! BTW, are you going
to TODCON again this year, Murray?

Good luck!

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Hunter Elliott" <nospam@gatewaycity.com> wrote in message
news:ft0pq8$r4e$1@forums.macromedia.com...
>
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:ft02in$1np$1@forums.macromedia.com...
>> Thanks, Hunter. I do ASP, but not so much anymore. I like PHP much
>> better.
>
> :) I don't disagree - but in the corporate world, I don't always have a
> choice. I'm trying to get us moved over to more linux/php/mysql instances,
> but it's slooooooooow going.
>

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:ft02in$1np$1@forums.macromedia.com...
> Thanks, Hunter. I do ASP, but not so much anymore. I like PHP much
> better.

:) I don't disagree - but in the corporate world, I don't always have a
choice. I'm trying to get us moved over to more linux/php/mysql instances,
but it's slooooooooow going.

"Hunter Elliott" <nospam@gatewaycity.com> wrote in message
news:ft02cr$1gm$1@forums.macromedia.com...
>
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:fsucnm$5ad$1@forums.macromedia.com...
>> Hunter:
>>
>> Thanks for that! I'm running down the road that Joe showed me. If I hit
>> a pothole, I'll give this a try....
>
> I use the DATEFORMAT as well, esp. since I have one site I do at work that
> is Windows/ASP and I am having to migrate to mySQL databases.... the
> differing date formats between the database and OS are a bit of a pain.
> If I remember, you do mainly PHP stuff, but if you're doing ASP, let me
> know and I can post some date tweaks I do for formatting the dates back
> and forth.

I'll just go ahead and post it in case there are others doing the ASP/mySQL
thing....

I had one table that had both an "end date" field for when the record would
stop displaying and a "last edited" to show when the entry was last touched
... I did this in the SQL:
SELECT *, DATE_FORMAT(EndDate, '%Y-%m-%d') AS EndDate, DATE_FORMAT(editDate,
GET_FORMAT(DATETIME, 'USA')) AS editDate FROM table.name WHERE recID = ?

Then, I created a couple of functions to replace date() and now() so they'd
get displayed/entered properly into the mySQL database. The "myDate()" and
"myNow()" would replace the date/now calls...

<%
Function myDate()
myDate = Year(Now) & "-" & Right("0" & Month(Now), 2) & "-" & Right("0"
& Day(Now), 2)
End Function
%>

<%
Function myNow()
myNow = Year(Now) & "-" & Right("0" & Month(Now), 2) & "-" & Right("0" &
Day(Now), 2) & " " & Right("0" & Hour(Now), 2) & ":" & Right("0" &
Minute(Now), 2) & ":" & Right("0" & Second(Now), 2)
End Function
%>

Thanks, Hunter. I do ASP, but not so much anymore. I like PHP much better.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================


"Hunter Elliott" <nospam@gatewaycity.com> wrote in message
news:ft02cr$1gm$1@forums.macromedia.com...
>
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:fsucnm$5ad$1@forums.macromedia.com...
>> Hunter:
>>
>> Thanks for that! I'm running down the road that Joe showed me. If I hit
>> a pothole, I'll give this a try....
>
> I use the DATEFORMAT as well, esp. since I have one site I do at work that
> is Windows/ASP and I am having to migrate to mySQL databases.... the
> differing date formats between the database and OS are a bit of a pain.
> If I remember, you do mainly PHP stuff, but if you're doing ASP, let me
> know and I can post some date tweaks I do for formatting the dates back
> and forth.
>

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:fsucnm$5ad$1@forums.macromedia.com...
> Hunter:
>
> Thanks for that! I'm running down the road that Joe showed me. If I hit
> a pothole, I'll give this a try....

I use the DATEFORMAT as well, esp. since I have one site I do at work that
is Windows/ASP and I am having to migrate to mySQL databases.... the
differing date formats between the database and OS are a bit of a pain. If
I remember, you do mainly PHP stuff, but if you're doing ASP, let me know
and I can post some date tweaks I do for formatting the dates back and
forth.