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

[vardhancse]

can change the number format to date format for that field.

As what ever data in a field, will be displayed in current selection.

[sujeetsingh]

Change the date format using date() date() functions.

[vinay_hg]

format that date fields/variables in script using Date(vfromdate,'DD/MM/YYYY') or format variable in front end.

[vardhancse]

what is the variable vFromDate and vToDate.

[ali_hijazi]

vFromDate = 41640

vToDate = 41941

I'm selecting on Snapshot_Date which has the above format (numbers)

[vardhancse]

change the number format for Snapshot_Date in document properties->number<tab>->date

[ali_hijazi]

NO

this only formats the display of SNAPSHOT_DATE

[mdmukramali]

Dear,

Can you check the attached file.

i hope it will help u.

Thanks,

Mukram

[ashfaq_haseeb]

Hi,

Ali I think that not directly possible.

Instead you can try by adding 1 proper date filed.

And hide numeric date field selection by using hide prefix statement.

And add field event trigger to select similar selection in proper date field.

Hope it helps.

Regards

ASHFAQ