topic Re: Convert Date in QlikView

Convert Date

mr_ramshini — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Convert Date

Tue, 17 May 2016 03:27:05 GMT

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

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

Re: Convert Date

mr_ramshini — Tue, 17 May 2016 04:09:56 GMT

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

Re: Convert Date

andrespa — Tue, 17 May 2016 08:18:17 GMT

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

Re: Convert Date

andrespa — Tue, 17 May 2016 08:25:02 GMT

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

Re: Convert Date

mr_ramshini — Wed, 18 May 2016 05:24:39 GMT

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

Re: Convert Date

andrespa — Wed, 18 May 2016 06:40:27 GMT

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

Re: Convert Date

mr_ramshini — Wed, 18 May 2016 06:53:43 GMT

Hi Andres prado

please give me your email

Re: Convert Date

andrespa — Wed, 18 May 2016 06:59:43 GMT

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

Cheers,

Andrés

Re: Convert Date

mr_ramshini — Wed, 18 May 2016 07:01:41 GMT

Thank Andres

i send it to your mail

Re: Convert Date

Wed, 18 May 2016 07:17:19 GMT

Hi Hossein

Qlikview Does not support Persian Calendar.

Please Join This Channel In Telegram and See First Post

Telegram.me/QlikviewGuide

Re: Convert Date

Gethyn — Wed, 18 May 2016 07:49:21 GMT

HI Hossein,

If you are using a SQL server then you could create this function (found on Stack Overflow) and use it to convert the date?

CREATE FUNCTION [CalculatePersianDate] ( @intDate DATETIME ) RETURNS NVARCHAR(max) BEGIN DECLARE @shYear AS INT ,@shMonth AS INT ,@shDay AS INT ,@intYY AS INT ,@intMM AS INT ,@intDD AS INT ,@Kabiseh1 AS INT ,@Kabiseh2 AS INT ,@d1 AS INT ,@m1 AS INT, @shMaah AS NVARCHAR(max),@shRooz AS NVARCHAR(max),@DayCnt AS INT DECLARE @DayDate AS NVARCHAR(max) SET @intYY = DATEPART(yyyy, @intDate) IF @intYY < 1000 SET @intYY = @intYY + 2000 SET @intMM = MONTH(@intDate) SET @intDD = DAY(@intDate) SET @shYear = @intYY - 622 SET @DayCnt = 5 IF ( ( @intYY - 1992 ) % 4 = 0) SET @Kabiseh1 = 0 ELSE SET @Kabiseh1 = 1 IF ( ( @shYear - 1371 ) % 4 = 0) SET @Kabiseh2 = 0 ELSE SET @Kabiseh2 = 1 SET @m1 = 1 SET @d1 = 1 SET @shMonth = 10 SET @shDay = 11 IF ( ( @intYY - 1993 ) % 4 = 0 ) SET @shDay = 12 WHILE ( @m1 != @intMM ) OR ( @d1 != @intDD ) BEGIN SET @d1 = @d1 + 1 SET @DayCnt = @DayCnt + 1 IF (@d1 = 32 AND (@m1 = 1 OR @m1 = 3 OR @m1 = 5 OR @m1 = 7 OR @m1 = 8 OR @m1 = 10 OR @m1 = 12)) OR (@d1 = 31 AND (@m1 = 4 OR @m1 = 6 OR @m1 = 9 OR @m1 = 11)) OR (@d1 = 30 AND @m1 = 2 AND @Kabiseh1 = 1) OR (@d1 = 29 AND @m1 = 2 AND @Kabiseh1 = 0) BEGIN SET @m1 = @m1 + 1 SET @d1 = 1 END IF @m1 > 12 BEGIN SET @intYY = @intYY + 1 SET @m1 = 1 END IF @DayCnt > 7 SET @DayCnt = 1 SET @shDay = @shDay + 1 IF (@shDay = 32 AND @shMonth < 7) OR (@shDay = 31 AND @shMonth > 6 AND @shMonth < 12) OR (@shDay = 31 AND @shMonth = 12 AND @Kabiseh2 = 1) OR (@shDay = 30 AND @shMonth = 12 AND @Kabiseh2 = 0) BEGIN SET @shMonth = @shMonth + 1 SET @shDay = 1 END IF @shMonth > 12 BEGIN SET @shYear = @shYear + 1 SET @shMonth = 1 END END IF @shMonth=1 SET @shMaah=N'فروردین' IF @shMonth=2 SET @shMaah=N'اردیبهشت' IF @shMonth=3 SET @shMaah=N'خرداد' IF @shMonth=4 SET @shMaah=N'تیر' IF @shMonth=5 SET @shMaah=N'مرداد' IF @shMonth=6 SET @shMaah=N'شهریور' IF @shMonth=7 SET @shMaah=N'مهر' IF @shMonth=8 SET @shMaah=N'آبان' IF @shMonth=9 SET @shMaah=N'آذر' IF @shMonth=10 SET @shMaah=N'دی' IF @shMonth=11 SET @shMaah=N'بهمن' IF @shMonth=12 SET @shMaah=N'اسفند' IF @DayCnt=1 SET @shRooz=N'شنبه' IF @DayCnt=2 SET @shRooz=N'یکشنبه' IF @DayCnt=3 SET @shRooz=N'دوشنبه' IF @DayCnt=4 SET @shRooz=N'سه‌شنبه' IF @DayCnt=5 SET @shRooz=N'چهارشنبه' IF @DayCnt=6 SET @shRooz=N'پنجشنبه' IF @DayCnt=7 SET @shRooz=N'جمعه' --SET @DayDate = @shRooz + " " + LTRIM(STR(@shDay,2)) + " " + @shMaah + " " + STR(@shYear,4) --پنجشنبه 17 اردیبهشت 1394 /* SET @DayDate = LTRIM(STR(@shDay,2)) + " " + @shMaah + " " + STR(@shYear,4) --17 اردیبهشت 1394 SET @DayDate = STR(@shYear,4) + "/"+LTRIM(STR(@shMonth,2)) + "/" + LTRIM(STR(@shDay,2)) --1394/2/17 --1394/02/17 */ SET @DayDate = REPLACE(RIGHT(STR(@shYear, 4), 4), ' ', '0') + '/'+ REPLACE(STR(@shMonth, 2), ' ', '0') + '/' + REPLACE(( STR(@shDay,2) ), ' ', '0') RETURN @DayDate END

Re: Convert Date

Mon, 18 Jul 2016 07:32:30 GMT

Hi, I had the same problem and solved it by loading a calendar table with Gregorian and persian dates and then using this formula:

FieldValue('PersianDate',FieldIndex('Date',YourDateToBeConverted))

Date and PersianDate are field names of the mentioned table.

Hope this proves to be useful