evaluate a date

[gtbikerider]

I want to show an event only if it's in the future, so I used...

<cfif #Dateformat(NOW(),"dd mm yyyy")# LTE "10 02 2006">
This is an event that occurs on 2nd Oct 2006
</cfif>

However I also only want to only show it, if it's less than (say) 60 days in the future - how would I evaluate the date in that way?

--
John

 

[ericaalicen]

You want to set a variable to the date Now() + 60 and then use that variable in your LTE comparison.

 

[imstillatwork]

make sure to put these dates in the query where they should be too.

i'm pretty sure all the db's can do date_add and date_diff, etc..with the proper syntax of course.

and drop the date format for NOW(). date format is not needed for comparisons in CFML

Kevin

http://www.lot-o-nothin.com/cfml/

Phase 1: Read the CFML Reference
Phase 2: ???
Phase 3: Profit!

 

[FALCONSEYE]

this is how you get the +60 future day

<cfset myFutureDate= DateFormat(DateAdd("d",60, now()), "MM/DD/YYYY")>

http://www.jetansolutions.com