T
THE_RAMONES
I'm trying to figure out a way to this without adding 7 queires to my macro..
I have a data set that has a column for Date and Time.. Below is an example
row_date interval split callsAnswered
27-Mar-08 10:00:00 PM 822 0
The time is in MDT - Mountain and I need to convert to EST.. I'm using a
dateadd to add 2 hours (DateAdd("n",+120,[interval])).. How do I round up the
day (10pm converts to 12am) without adding an additinal column.. I was
thinking to add a column where i add an IIF(Interval >=12:00am and <=1:30am,
1,0) Then adding that amount to the date field... Etc...
Anyways I know how to do it however its going to take about 7 queries and
one append query to prevent dups... Any thoughts...
Ramon
I have a data set that has a column for Date and Time.. Below is an example
row_date interval split callsAnswered
27-Mar-08 10:00:00 PM 822 0
The time is in MDT - Mountain and I need to convert to EST.. I'm using a
dateadd to add 2 hours (DateAdd("n",+120,[interval])).. How do I round up the
day (10pm converts to 12am) without adding an additinal column.. I was
thinking to add a column where i add an IIF(Interval >=12:00am and <=1:30am,
1,0) Then adding that amount to the date field... Etc...
Anyways I know how to do it however its going to take about 7 queries and
one append query to prevent dups... Any thoughts...
Ramon