Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
date(Created_date,'DDMMMYY') as Created_date
use this in ur script
Hi,
You need to put some thing MonthStart(creation_date) and MonthEnd(creation_date) to date column
Regards,
Anand
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