Re: Making several variables into 1 variable

On 7/28/09 8:41 AM, "Bob McConnell" <rvm@CBORD.com> wrote: From: Ashley Sheridan > On Tue, 2009-07-28 at 09:32 -0400, Miller, Terion wrote: >> I need to take this: >> >> $pastDays = strtotime("-30 days"); >> >> >> >> $past_day = date("d", $pastDays); >> >> $past_month = date("m", $pastDays); >> >> $past_year =date("y", $pastDays); >> >> >> And make it into one var to compare to a db field that is formatted like >> 00/00/00 >> >> > Erm, why don't you do this: > > $pastDays = strtotime("-30 days"); > $date = date("d/m/y", $pastDays); > > The date() function allows you to mix in all sorts of characters into > the output it formats, and you can escape characters that have special > meaning with a slash '\' character. The problem with that is if that field is a string, and not formatted as YY/MM/DD, then a simple compare won't work in January. You have to break it down into the three components and compare each one in turn. Bob McConnell Hi Bob, they are all formatted in the db as mm/dd/yy