topic Re: Converting Date from DD-MMM-YYYY to DD/MM/YYYY in App Development

Converting Date from DD-MMM-YYYY to DD/MM/YYYY

Aspiring_Developer — Thu, 08 Sep 2022 08:01:32 GMT

Hello All,

I have date in below format :-

I am trying to convert it into below format :-

I tried this expression in front end = Date(Date#(ISSUECLOSED,'DD-MMM-YYYY'),'DD/MM/YYYY').

It works in front end but I have to create this field in backend and I am using similar script but it is giving me blank like below :-

Can anyone please help me ?

It seems the date is in text format so I tried to convert it into num using below :-

But still it is giving us blank value .

Thanks in advance

Re: Converting Date from DD-MMM-YYYY to DD/MM/YYYY

BrunPierre — Thu, 08 Sep 2022 09:32:12 GMT

Your conversion should work as it does for me

LOAD Date(Date#(ISSUE_CLOSED,'DD-MMM-YYYY'),'DD/MM/YYYY') as NewDateField Inline[ ISSUE_CLOSED, 01-APR-2020 01-APR-2021 01-AUG-2021];

So perhaps set the below variable in the script

SET DateFormat ='DD/MM/YYYY';

Re: Converting Date from DD-MMM-YYYY to DD/MM/YYYY

RsQK — Thu, 08 Sep 2022 09:27:37 GMT

I tried forcing those dates as text, I am able to convert them via DATE#. But, if all else fails, you could try something like this:

LET v_min_date = FLOOR(ADDYEARS(YEARSTART(TODAY()),-4)); LET v_max_date = FLOOR(TODAY()); temp_date_list: LOAD $(v_min_date) + RECNO() -1 AS date AUTOGENERATE $(v_max_date)-$(v_min_date)+1; temp_date_list2: LOAD DATE(date,'DD.MM.YYYY') AS date_num, UPPER(DATE(date,'DD-MMM-YYYY')) AS date_text RESIDENT temp_date_list; DROP TABLE temp_date_list; data: LOAD TEXT(ISSUE_CLOSED) AS ISSUE_CLOSED INLINE [ ISSUE_CLOSED 01-APR-2020 01-APR-2021 01-APR-2022 01-AUG-2021 01-AUG-2022 01-DEC-2020 01-DEC-2021 ]; LEFT JOIN (data) LOAD date_text as ISSUE_CLOSED, date_num as ISSUE_CLOSED_NEW RESIDENT temp_date_list2; DROP TABLE temp_date_list2; DROP FIELD ISSUE_CLOSED; RENAME FIELD ISSUE_CLOSED_NEW TO ISSUE_CLOSED;

Re: Converting Date from DD-MMM-YYYY to DD/MM/YYYY

Aspiring_Developer — Thu, 08 Sep 2022 09:33:11 GMT

I am using Qliksense. Could that be a reason ?

Re: Converting Date from DD-MMM-YYYY to DD/MM/YYYY

RsQK — Thu, 08 Sep 2022 09:51:21 GMT

I tested using Qlik Sense aswell, so probably not. Might be locale settings...

Re: Converting Date from DD-MMM-YYYY to DD/MM/YYYY

BrunPierre — Thu, 08 Sep 2022 15:02:23 GMT

The scripting syntax in QlikView and Qlik Sense is essentially the same.

Did you change the default format of the date? What was the outcome?