Selecting dates

[fredericvillemi]

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]

date(Created_date,'DDMMMYY') as Created_date

use this in ur script

[its_anandrjs]

Hi,

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

Regards,

Anand

[fredericvillemi]

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