Re: [cftalk] calculating the date and time.

2003-08-14 Thread Allan Cliff
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 calculat

Re: [cftalk] calculating the date and time.

2003-08-12 Thread Allan Cliff
- Original Message - From: ColdFusion Programmer To: CF-Talk Sent: Wednesday, July 30, 2003 12:48 PM Subject: [cftalk] calculating the date and time. Spot on Allan, this is what I was trying to do. Can you show me how to calclulate the from-to date time in

Re: [cftalk] calculating the date and time.

2003-08-05 Thread Allan Cliff
ect: [cftalk] calculating the date and time. not quite as I was expecting. Take the current time, its 11:55 am GMT, I want the result to be (29 Jul 2003 11:00 - 30 Jul 2003 10:59) > >0)> > > > >- Original Message - >

Re: [cftalk] calculating the date and time.

2003-08-05 Thread Allan Cliff
That should have read Yesterday and not LastWeek but you know what i mean - Original Message - From: Allan Cliff To: CF-Talk Sent: Wednesday, July 30, 2003 12:53 PM Subject: Re: [cftalk] calculating the date and time. - Original

[cftalk] calculating the date and time.

2003-07-30 Thread ColdFusion Programmer
on Programmer >To: CF-Talk >Sent: Wednesday, July 30, 2003 1:00 PM >Subject: [cftalk] calculating the date and time. > > >not quite as I was expecting. Take the current time, its 11:55 am GMT, >I want the result to be

RE: [cftalk] calculating the date and time.

2003-07-30 Thread Philip Arnold
> not quite as I was expecting. Take the current time, its > 11:55 am GMT, I want the result to be > (29 Jul 2003 11:00 - 30 Jul 2003 10:59) Do you want it from the end of the previous hour? BTW, the reason I pointed you at DateAdd() and no further is that you should be able to work it out for y

Re: [cftalk] calculating the date and time.

2003-07-30 Thread Allan Cliff
ect: [cftalk] calculating the date and time. not quite as I was expecting. Take the current time, its 11:55 am GMT, I want the result to be (29 Jul 2003 11:00 - 30 Jul 2003 10:59) > >0)> > > > >- Original Message - >

[cftalk] calculating the date and time.

2003-07-30 Thread ColdFusion Programmer
nesday, July 30, 2003 12:48 PM >Subject: [cftalk] calculating the date and time. > > >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) &

Re: [cftalk] calculating the date and time.

2003-07-30 Thread Allan Cliff
That should have read Yesterday and not LastWeek but you know what i mean - Original Message - From: Allan Cliff To: CF-Talk Sent: Wednesday, July 30, 2003 12:53 PM Subject: Re: [cftalk] calculating the date and time. - Original

Re: [cftalk] calculating the date and time.

2003-07-30 Thread Allan Cliff
- Original Message - From: ColdFusion Programmer To: CF-Talk Sent: Wednesday, July 30, 2003 12:48 PM Subject: [cftalk] calculating the date and time. Spot on Allan, this is what I was trying to do. Can you show me how to calclulate the from-to date time in

[cftalk] calculating the date and time.

2003-07-30 Thread ColdFusion Programmer
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 s

Re: [cftalk] calculating the date and time.

2003-07-30 Thread Allan Cliff
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 calculat

calculating the date and time.

2003-07-30 Thread ColdFusion Programmer
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 >

RE: calculating the date and time.

2003-07-30 Thread Philip Arnold
> 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 wan

calculating the date and time.

2003-07-30 Thread Allan Clarke
Hi All, 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 displ