Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
fredericvillemi
Contributor III

Selecting dates

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

Tags (2)
3 Replies
SunilChauhan
Esteemed Contributor

Selecting dates

date(Created_date,'DDMMMYY') as Created_date

use this in ur script

Re: Selecting dates

Hi,

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

Regards,

Anand

fredericvillemi
Contributor III

Selecting dates

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