How to change Interval into NUM

[#1]

Hi,

I am abstracting interval from starttime and endtime. but the format for the same is time format. i want to use it in a calculation but when i changes it to num problem arises.please help.

Regards,

piyush

[#2]

hi

try this

num(date(datefieldintervalcalculation))

[#3]

Hi,

I am using Interval([Stattime]-[Endtime]). please use above calculation on this. i didn't get it.

Regards,

Piyush

[#4]

Hi Try like this..

Interval(Date(StartDate,'DD/MM/YYYY') -Date(ENDDate,'DD/MM/YYYY') ,'D') it will give you number of days...

Thanks,

Selva

[#5]

hi

suppose your starttime and endtime in same date format.

then

num(interval( Stattime-Endtime, 'D hh:mm' ))

[#6]

Hi,

We cannot use num before interval cos its format changes.but Got answer after trying.

Regards

Piyush.

[#7]

Hi,

Got Answer. Thanks for ur valuable suggestion

Regards,

Piyush

[stantrolav]

Mark Answer that is correct. It'll help community not to spend time for reading idle posts.