topic Re: how to transform a date with scripting in QlikView

how to transform a date with scripting

Wed, 25 Nov 2020 16:16:04 GMT

Hello there,

i would like to split the following cell "date de création" into DATE and TIME, how to proceed in the Scripting...

thanks

SET ThousandSep="'";
SET DecimalSep='.';
SET MoneyThousandSep="'";
SET MoneyDecimalSep='.';
SET MoneyFormat='fr. #''##0.00;fr.-#''##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';
SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

LOAD Nom,
Prénom,
[Adresse e-mail],
Status,
Langue,
[Champ libre 1],
[Champ libre 2],
Pays,
Date de création

FROM

(ooxml, embedded labels);

Re: how to transform a date with scripting

sunny_talwar — Wed, 04 May 2016 08:14:49 GMT

Try like this:

SET ThousandSep="'";
SET DecimalSep='.';
SET MoneyThousandSep="'";
SET MoneyDecimalSep='.';
SET MoneyFormat='fr. #''##0.00;fr.-#''##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='YYYY-MM-DD hh:mm:ss';
SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

LOAD Nom,
Prénom,
[Adresse e-mail],
Status,
Langue,
[Champ libre 1],
[Champ libre 2],
Pays,
Date(Floor([Date de création])) as Date,

Time(Frac([Date de création])) as Time
FROM

(ooxml, embedded labels);

Re: how to transform a date with scripting

Wed, 04 May 2016 08:18:53 GMT

Thanks great for your support.

Re: how to transform a date with scripting

Anonymous — Wed, 04 May 2016 08:48:28 GMT

by using the date and date # function to implemented the which format you like in that format.