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.

[#2]

hi,

I can get the results but in the output it also throws shows date field which i dont want. Have you noticed the same in qvw file i posted.

[#3]

I explained my scenaraio detaily, can u please help me with some expressions.

[kaushiknsolanki]

Hi,

     If you want the same in tablular format then you can hide the dimension fields which dont want to show.

Regards,

Kaushik Solanki

[jagan]

Hi,

You can hide the Dimensions in straight table using

Chart Properties -> Presentation -> Select Hide column for dimensions.

Regards,

Jagan.

[#6]

I am not getting any option to hide the dimensions under presentation tab,

[jagan]

Hi,

Check the attached file, I am using QV 9 SR2.

Regards,

jagan.