DateAdd function to add 15 minutes

[crac74]

Hi,

I'm working on CR 8.5 and I'd like to create a field which adds 15 minutes to my database time field.
The field {iAgentPerformanceStat.Time} returns time by intervals (04:00, 04:15, 04:30,...)

My new field is @Time+15
I wrote:

DateAdd ("N", 15,{iAgentPerformanceStat.Time})

but it doesn't work (I'm a beginner...)

 

[lbass]

Do you have a date field? Then you could do the following:

time(dateadd("n",15,datetime({table.date},{iAgentPerformanceStat.Time})))

-LB

 

[crac74]

my date field is {iAgentPerformanceStat.TimeStamp}

but when I try to save the this formula there is an error :
{iAgentPerformanceStat.Time} is not seen as an hour...

 

[lbass]

If you right click on {iAgentPerformanceStat.Time} and choose "Browse field data" what datatype does it say at the top? And I guess you are saying that {iAgentPerformanceStat.TimeStamp} is a separate date field? Please confirm its datatype also.

-LB

 

[crac74]

{iAgentPerformanceStat.Time}
type = string
length = 5
data = 00:00, 00:15,...

{iAgentPerformanceStat.TimeStamp}
type = date
data = 08/07/2004, ...

they are 2 separate tables of the database

thanks for your help.

 

[lbass]

Try:

time(dateadd("n",15,datetime({iAgentPerformanceStat.TimeStamp},
time({iAgentPerformanceStat.Time}))))

-LB

 

[crac74]

yes it works !!!
just a detail, I would like to have only hours and minutes like in the field "time" (hh:mm)
I have hh:mm:ss

 

[lbass]

Right click on the formula->format->field->datetime->select "14:01" or "2:01 pm".

-LB

 

[ElTech]

I have the same database.

How would I display an hourly total instead of a 15 interval total?

 

[lbass]

Create a formula {@datetime}:

datetime({iAgentPerformanceStat.TimeStamp},
time({iAgentPerformanceStat.Time}))

Then insert a group on this and choose "print on change of hour". Then you can insert summaries on your data at the hourly group level.

-LB