On 7/9/00, Gordon Burns penned:
><cfset
>Startdate=#DateFormat(CreateDate(Year(Now()),Month(Now())-1,01),"dd mm yy")#>
>
>will give me the first day of June ie the first day of last month.
>
>I am struggling to get syntax for the last day of the month.

Try (once startdate is set).

<cfset enddate = dateformat(dateadd('D', daysinmonth(startdate) - 1, 
startdate),"dd mm yy")>
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to