topic Selecting dates in QlikView

Selecting dates

fredericvillemi — Tue, 23 Aug 2011 09:05:56 GMT

Hi,

i have a project with a very special way of declaring months.

People make reports with data from 21st of a month to 20th of next month.

How can i create in script the conversion of a "creation_date" to a field with such results "21Dec10 to 20Jan11", "21Jan11 to 20Feb11", etc

Thanks

SunilChauhan — Tue, 23 Aug 2011 09:12:18 GMT

date(Created_date,'DDMMMYY') as Created_date

use this in ur script

its_anandrjs — Tue, 23 Aug 2011 09:20:10 GMT

Hi,

You need to put some thing MonthStart(creation_date) and MonthEnd(creation_date) to date column

Regards,

Anand

fredericvillemi — Tue, 23 Aug 2011 09:47:04 GMT

in fact what i want to have is a formula to convert my creation date to

21Dec10-20Jan11 format

I mean if creation_date is '10-may-2011' it will appear as '21apr11-20may11'

thanks