I'm in Brisbane at the minute ;)
Spike
Mike Kear wrote:
>
>
> What a wonderful thing this list is. Here we are, less than 30 minutes
> after I asked a question I have an answer from the other side of the globe.
> This is just magic.
>
>
>
> Thanks Spike! Looks exactly what I want.
>
>
>
>
>
>
>
> Cheers,
>
> Michael Kear
>
> Windsor, NSW, Australia
>
> AFP Webworks.
>
>
>
>
>
>
>
> -----Original Message-----
> From: Spike [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 5 November 2003 4:53 PM
> To: CF-Talk
> Subject: Re: Calculate the date next Sunday
>
>
>
> Something like this should do:
>
> <cfset dateOffset = 8-dayOfWeek(Now())>
>
> <!--- If you want to set the effective date of the transaction as today
> if the day is sunday --->
> <cfif dateOffset GT 1>
> <cfset targetDate = dateAdd('d',dateOffset,Now())>
> <cfelse>
> <cfset targetDate = Now()>
> </cfif>
>
> <!--- If you want to make sure that transactions take at least 24 hours --->
> <cfset targetDate = dateAdd('d',dateOffset,Now())>
>
> Spike
>
> Mike Kear wrote:
>
>
>>I have a task where I have to insert the effective date of a transaction,
>>which is the following Sunday, regardless of the day the form is
>
> submitted.
>
>>
>>
>>Anyone know of a UDF or other functionality that'll work that out?
>>
>> >
>>Cheers,
>>
>>>Michael Kear
>>>Windsor, NSW, Australia
>>>AFP Webworks.
>>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
