topic Function Left doesn´t read correctly the date. in QlikView

Function Left doesn´t read correctly the date.

Wed, 25 Nov 2020 16:16:04 GMT

Im trying to extract the year and month, with functions left and mid, but when I extract the year from '2016-05-01', read 2014 instead of 2016.

tamilarasu — Mon, 04 Jul 2016 16:43:30 GMT

Fernando,

Try this,

Let Year= Left('$(vInicioPrincipalidad)',4);

remi_roland — Mon, 04 Jul 2016 16:47:16 GMT

Hi,

It's absolutely normal.

Using $(vInicioPrincipalidad) you ask to qlikview an evaluation of the variable vInicioPrincipalidad so it will operate:

2016 - 1 - 1 = 2014 (read - as substraction operator)

You should force use your variable as a text string to do that use single quotes:

let year = left('$(vInicioPrincipalidad)',4);

or in this case you can use the function year to extract year from a date:

let year = year(vInicioPrincipalidad);

Hope it will help.

Regards.

antoniotiman — Mon, 04 Jul 2016 16:56:00 GMT

Try

Let Year = Left(vInicioPrincipalidad,4);

Mon, 04 Jul 2016 20:10:42 GMT

Thanks Remi, it was really useful!