formatting what is displayed on current selection box

[ali_hijazi]

Hello got a date field which is numbers (QlikView format)

I have a button which selects in this field as follows

='>= ' & $(vFromDate) & ' <= ' & $(vToDate)

the result is fine but what the end user sees is as follows:

End users are not developers

can this be translated to something like >= 1/1/2014 <= 10/29/2014 ?

Please advise

[ali_hijazi]

ah okay sounds smart solution

I know the suggestions that were proposed here are not valid

[mario-sarkis]

i have a field that contain a strating time as >>> '7423590' i need to show it like this 7:42:32:90 am (hours ,minutes,seconds,milliseconds)

and another filed that contain the ending time as >>'7435789' i need to show it like this 7:43:57:89 am (hours, minutes,seconds,milliseconds)

and finaly i need a field that will show me the diffrence time between the starting and the ending time .

Thank you,

[ashfaq_haseeb]

Hi

This is what you need.

=interval((Time#(Left(Repeat('0',6-Len(7435789))&7435789,1) & ':' & Mid(Repeat('0',6-Len(7435789))&7435789,2,2)& ':' &mid(Repeat('0',6-Len(7435789))&7435789,4,2)& ':' &right(Repeat('0',6-Len(7435789))&7435789,2),'hh:mm:ss:ff'))-(Time#(Left(Repeat('0',6-Len(7423590))&7423590,1) & ':' & Mid(Repeat('0',6-Len(7423590))&7423590,2,2)& ':' &mid(Repeat('0',6-Len(7423590))&7423590,4,2)& ':' &right(Repeat('0',6-Len(7423590))&7423590,2),'hh:mm:ss:ff')))

Regards

ASHFAQ

[mario-sarkis]

Hi ASHFAQ,

Thank you for your help,it works Successfully 

but i used 8-Len instead of 6-Len

Regards

Mario

[ali_hijazi]

ah I just saw it

I also sent you an email

almost the same

[ashfaq_haseeb]

Hi can u mark it as correct

Regards

ASHFAQ

[mario-sarkis]

hehe Thank you ALI

[mario-sarkis]

of caurse i can but where i am sorry i Am a fresh user here