Convert Date

[mr_ramshini]

Hi every body

I have a qlikview file and i want get system date and change it to persian date

and after i want show persian date at text box

please help me

Thanks

[#2]

=WeekDay(today())&',  '& Date(Date#(today(), 'MM/DD/YYYY'), 'MMM DD, YYYY')

here today() is todays date i.e, system date

[mr_ramshini]

Hi saikrishna

Thanks for your help but i need to convert system date to persian date and after show it on textbox

please help me

[andrespa · Accepted solution]

Hi, do you mean something like this:

If yes, I would say that's not possible on Qlikview. At least not without a thirdparty software. Maybe you could find something useful here:

QlikMarket

Hope it helps,

Andrés

[andrespa]

Here is something else that could be useful for you:

https://community.qlik.com/thread/117104

Apparently as I said before, Qlikview doesn't support Persian date natively, so you must build a module in another language/tool to convert Gregorian date to persian date, and then export it to Qlikview. Not sure how to do that but on that thread and searching on the internet you should find something.

Cheers,

Andrés

[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

[andrespa]

Hi, could you please post some sample code or a partial part of your qvd?? Otherwise I'm not going to be able to help you.

Cheers,

Andrés

[mr_ramshini]

Hi Andres prado

please give me your email

[andrespa]

Hi, I've just sent you a private message with my mail. Please confirm if you got it.

Cheers,

Andrés

[mr_ramshini]

Thank Andres

i send it to your mail