Date Format

[crow57]

This code echos the right date but not in the desired format.
<?php echo $row_rsYb_memb['Date_Joined']; ?> PRODUCES "Member Since: 2000-06-01"

When I try to format the date into Month and year using the following code the date is wrong!
<?php echo date('M Y', strtotime($row_rsYb_memb['Date_Joined'])); ?> Member Since: Dec 1969

Adding insult to injury the repeat region doesn't work either. (using Dreamweaver)

[dagon]

something odd there as my test shows the date should format properly

$f="2000-06-01";
 echo date('M Y', strtotime($f));
//output: Jun 2000

hows the date stored? what's the date field formant (if its in a db)?

[crow57]

the field type is date.

[Weedpacket]

Looks like it should work to me, too; have you considered formatting it in the query instead?

[crow57]

Yes that's what I had to do nd it works, turns out my problem was that I had concatenated the date with a text field which results in a text which could not be reformatted because it was no longer a date!