Discussion Board for collaboration related to Creating Analytics for QlikView.
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
date(Created_date,'DDMMMYY') as Created_date
use this in ur script
You need to put some thing MonthStart(creation_date) and MonthEnd(creation_date) to date column
in fact what i want to have is a formula to convert my creation date to
I mean if creation_date is '10-may-2011' it will appear as '21apr11-20may11'