Re: One year behind

Oops. Scratch my reply. I somehow missed the Now() portion of your example. On 1/8/07, Crow T. Robot <[EMAIL PROTECTED]> wrote: > > Try supplying the full date, not just the year portion. > > On 1/8/07, Orlini, Robert <[EMAIL PROTECTED]> wrote: > > > > How do I date format a year behind the curr

Re: One year behind

Terry Sta. Maria wrote: > Also, the dateAdd function uses '' to specify year (where 'y' specifies > day of year). > > So "#dateAdd('y',-1,now(), )#" should be "#dateAdd('',-1,now(), > )#". > > Terry > > Terry: dateAdd only takes three arguments. Not four. |*DateAdd*|("/datepar

Re: One year behind

You've got too many arguments in dateAdd. Get rid of the , part. Cheers, Chris Orlini, Robert wrote: > How do I date format a year behind the current year? In other words, I would > like to populate a dropdown with 2006 and 2007. > > Tried this, but no dice: > > "#dateAdd('y',-1,now(), )

Re: One year behind

Try supplying the full date, not just the year portion. On 1/8/07, Orlini, Robert <[EMAIL PROTECTED]> wrote: > > How do I date format a year behind the current year? In other words, I > would like to populate a dropdown with 2006 and 2007. > > Tried this, but no dice: > > "#dateAdd('y',-1,now(), y

Re: One year behind

Also, the dateAdd function uses '' to specify year (where 'y' specifies day of year). So "#dateAdd('y',-1,now(), )#" should be "#dateAdd('',-1,now(), )#". Terry > How do I date format a year behind the current year? In other words, I > would like to populate a dropdown with 200

RE: One year behind

Robert, Try #Year(Dateadd('y',-1,now()))# -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Monday, January 08, 2007 11:30 AM To: CF-Talk Subject: One year behind How do I date format a year behind the current year? In other words, I would like to populate a drop

RE: One year behind

"#dateAdd('y',-1,now(), )#" That is not a valid function. You could do this. #dateFormat(dateAdd('',-1,now()),"")# OR Year(now()) - 1 -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | |

RE: One year behind

Close But not quite: #Year(now())# (will give you 2007) #Year(dateAdd('y',-1,now()))# (will give you 2006) Or you can do the long way: #DateFormat(now(), '')# (will give you 2007) #DateFormat(dateAdd('y',-1,now()), '')# (will give you 2006) -Original Message- From: Orlini,

RE: One year behind

year(now()) - 1 should work ~Brad -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Monday, January 08, 2007 11:30 AM To: CF-Talk Subject: One year behind How do I date format a year behind the current year? In other words, I would like to populate a dropdown with

RE: one year behind

And it could be done even simpler with the year() function. ~Brad -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 2:25 PM To: CF-Talk Subject: RE: one year behind First thing, remember to try and avoid using a function name as a

RE: one year behind

: CF-Talk Subject: RE: one year behind Doesn't account for leap years. Sandra Clark Close Sandra. 'Y' if for Day of Year, '' is for year. So it should be: -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - |

RE: one year behind

First thing, remember to try and avoid using a function name as a variable name. Second, remember that don't need the pound sign on the right side (unless you're inside quotes). Also, this could be done simpler like so: -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECT

RE: one year behind

Doesn't account for leap years. Sandra Clark Close Sandra. 'Y' if for Day of Year, '' is for year. So it should be: -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "C code. C c

RE: one year behind

Thanks Agha and Greg -Original Message- From: Mehdi, Agha [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 2:53 PM To: CF-Talk Subject:RE: one year behind Option 1: Option 2: Agha Mehdi IDT - eBusiness Program Manager -Original Message- From

Re: one year behind

Spaces are not allowed in variable names. :) On 10/18/06, Sandra Clark <[EMAIL PROTECTED]> wrote: > > Doesn't account for leap years. > > > > > Sandra Clark > == > http://www.shayna.com > Training in Cascading Style Sheets and Accessibility > > -- Aaron Rouse http:

RE: one year behind

t: RE: one year behind Option 1: Option 2: Agha Mehdi IDT - eBusiness Program Manager -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:45 AM To: CF-Talk Subject: one year behind How can I set this to be one year behind? Right n

RE: one year behind

Option 1: Option 2: Agha Mehdi IDT - eBusiness Program Manager -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 11:45 AM To: CF-Talk Subject: one year behind How can I set this to be one year behind? Right now it displays 2006; I wo

Re: one year behind

try using dateadd() it asks for a part, like year, and then the offset, so you could do -1.. Should work for you On 10/18/06, Orlini, Robert <[EMAIL PROTECTED]> wrote: > How can I set this to be one year behind? Right now it displays 2006; I would > like it to display 2005 > > > > Thanks. > > Ro