How can sort special format date in search object's results?

[#1]

I have a search object that linked to a field contains Persian dates , I wanna sort in in decreasing way

[#2]

dear Ralf

I attached a sample and want to persian date in list box

thanks

[rbecher]

Please find attached. You can select Today indirectly via GREGORIAN_DATE.

- Ralf

[mr_ramshini]

Hi Ralf

Can i do it without list box?

i want convert system date to persian date and show it on text box

please help me

Thanks

[mr_ramshini]

Hi

i want change date to persian date

please help me

Thanks

[rbecher]

Hi Hossein,

if you use my app above you can code in a text box:

=minstring({1<QV_DATE_NUM={"$(=num(today(1)))"}>} PERSIAN_DATE)

- Ralf

[mr_ramshini]

Hi

Thanks for your help

but i have a qv file and i want show the last execution time to persian date on text box

but i can't solve it

please help me

[rbecher]

Do you mean the date of last script load? This would be:

=minstring({1<QV_DATE_NUM={"$(=num(today(0)))"}>} PERSIAN_DATE)

[rbecher]

ReloadTime() as Persian Date would be:

=minstring({1<QV_DATE_NUM={"$(=num(today(0)))"}>} PERSIAN_DATE)
& ' ' & Time(TimeStamp#(ReloadTime()))

- Ralf

[mr_ramshini]

Hi Ralf

your answer was very useful

but i can do it without persian_date_rb file?

In fact i want change my system date to persian date with out i use of persian_date_rb file?

[rbecher]

Hi Hossein,

no, because QlikView doesn't know a Persian date..

- Ralf