how can take the time between two dates but in date time format

[#1]

I have two fields in date time format and I need  the time between both.

how can I do that.

best regards.

[Anonymous]

Use the Interval() function.

[#3]

but if I need in a Static Box.

best regars

[Anonymous]

I presume you mean a Text Box.  If so then put this sample in as the expression :

     =(Interval( date(today()) - date(today()-.5)  ))

Then adjust as per your needs.

[#5]

this is the object but I cant made an expresión here , I was thinking,

if I can made in the script an expresión?

best regards

[Anonymous]

Roldan

That looks like a Statistics Box and can only show statistics for a single field, and has nothing to do with your original question.

Please clarify.

[#7]

Sorry for not bee explicit

[aveeeeeee7en]

See this:

Time subtract between two time stamps

Regards

Aviral Nag

[MarcoWedel]

Hi,

your screenshot also suggests, that your Time field is loaded as text and not as a real Time, Date or Timestamp, i.e. there is no underlying numerical value to calculate with. During load use the date#, time# or timestamp# function to correct this (or set your variables TimeFormat, DateFormat or TimestampFormat accordingly).

See attachment.

Besides you can also change the format shown in the statistic box:

hope this helps

regards

Marco

[#10]

thanks a lot this is where I need,

sorry one more question,

in the static box seem like a command 'Time', how can I do that?

thanks a lot