Writing a Expression to subract dates,

[#1]

Hi,

I want to write a expression in which i need to subtract the two dates field and i need to convert the result field in to hours, days and minutes. I am looking for the syntax to follow and little confused with the functions to use,

Any help will be highly appreciated,

Thanks,

Praveen.

[kaushiknsolanki]

Hi,

  Can you please share what you tried and what u expect.

  If possible pls post the qvw file.

Regards,

Kaushik Solanki

[#3]

interval(DISCHARGE_TIME - ADMISSIONTIME,'hh:mm:ss') am using this expression in the output it shows like

('2010-11-12' 55:11:22)

('2011-15-16' 42:10:01)

I need only hrs:mm:ss in the output and i dont need date in the output. Also i need to sum all the hrs, minutes and seconds and display it in one row,

For above eg,

the output i like to see is  97:21:23..

Any suggestions to write expressions?

[kaushiknsolanki]

HI,

     It seems that the data formate for DATE field is not proper.

     If possible please sens us the sample file.

Regards,

Kaushik Solanki

[#5]

Hi,

How to upload the sample file i find no ways to attach the file.

Kaushik Solanki wrote:

HI,

     It seems that the data formate for DATE field is not proper.

     If possible please sens us the sample file.

Regards,

Kaushik Solanki

[CELAMBARASAN]

Hi,

     Use Advanced editor which is right of the reply editor.

Celambarasan

[#7]

Hi,

Pls find the qvw file. Please find the last tab of the report.

Thanks,

Praveen.

[#8]

i have attached the qvw file. check to it.

[jagan]

Hi,

Check the attached file, I added the dimensions Discharge and Admission Time and removed D in the Time format.  It displays the difference between the two in hours: seconds format.

Regards,

Jagan.

[#10]

Hi,

can you send me the expression alone here, i cant open the qvw u posted , since i am using personal edition.

Thanks,

Praveen.

[jagan]

Hi,

I used this expression

=interval( ADMISSIONTIME - DISCHARGE_TIME,'hh:mm')

Regards,

Jagan.