Spot on Allan, this is what I was trying to do. Can you show me how to calclulate the
from-to date time in the last 24 hours
In the last 24 hours (29 Jul 2003 10:00 - 30 Jul 2003 09:59)
Many Thanks
Allan
><CFIF LookingAt IS "Week">
><CFSET Today = CreateDateTime(Year(Now()),Month(Now()),Day(Now()),0,59,
>0)>
><CFSET LastWeek = DateAdd("N",1,DateAdd("D",-7,Today))>
></CFIF>
>
>I haven't tested this so there maybe small errors but something like
>this??
>----- Original Message -----
>From: ColdFusion Programmer
>To: CF-Talk
>Sent: Wednesday, July 30, 2003 12:24 PM
>Subject: [cftalk] calculating the date and time.
>
>
>How do I get the calculate the from time to start at 01:00 am and the
>to time to end at 00:59 am. Can you please show me how to get the date
>and time in the format mentioned below
>
>In the last 7 days (23 Jul 2003 01:00 - 30 Jul 2003 00:59)
>
>
>>> I was hoping somebody could help me. I'm trying to
>>> display the date and time. This is how I want to
>>> display it:
>>>
>>> If the current time is 10:05, I want to display the
>>> time in this format:
>>>
>>> In the last hour (09:05 - 10:04)
>>>
>>> If the current time is 10:05 and the date is 30.July,
>>> I want to display the date time in this format:
>>>
>>> In the last 24 hours (29 Jul 2003 10:00 - 30 Jul 2003
>>> 09:59)
>>>
>>> If the current time is 10:05 and the date is 30.July,
>>> I want to display the date time in this format:
>>>
>>> In the last 7 days (23 Jul 2003 01:00 - 30 Jul 2003
>>> 00:59)
>>>
>>> If the current time is 10:05 and the date is 30.July,
>>> I want to display the date time in this format:
>>>
>>> In the last 30 days (30 Jun 2003 01:00 - 30 Jul 2003
>>> 00:59)
>>
>>Look into DateAdd() - you can add any amount of time to a date, from
>>seconds to years
>>
>>If you want to remove 7 days, you can just do DateAdd("d", -7,
>Now())
>>
>>Hope this helps
>>
>>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
