<cfset EndDate = DateFormat(StartDate + DaysInMonth(StartDate) - 1, "dd mm yy")>
Jim
-----Original Message-----
From: Gordon Burns <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Sunday, July 09, 2000 1:48 AM
Subject: First and last day of Month
><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.
>
>I had thought that getting the first day of this Month then minus
>one day would be the most obvious but can not seem to get the syntax correct.
>
>I have tried using days in month but can not seem to get the syntax
>correct there.
>
>I also need to work in European date format dd mm yy.
>
>If you have a date as a variable how do you add or subtract a
>variable number of days?
>
>Any help appreciated.
>
>
>Gordon
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.