Date Format

[NavinReddy]

Hi Community

i have date format like the way(02/11/2013)

But how can i set This date like as(Feb 11,2013)

Thanks

Rohith

[kaushiknsolanki]

Hi,

     Try this,

     Date(Date,'MMM DD,YYYY')

Regards,

Kaushik Solanki

[NavinReddy]

Hi kaushik,

im using this function, date(Max(Week-7,'Month/DD/YYYY'))

its not working for me

Thanks,

rohith

[kaushiknsolanki · Accepted solution]

Hi,

     Try this

     Date(Max(Week)-7,'MMM/DD/YYYY')

Regards,

Kaushik Solanki

[NavinReddy]

Thanks you its working fine

[NavinReddy]

Hi,

help me its not working

="Total Calls in Previous Week" ( '&date(Max(Week)-7,'MMM DD,YYYY') -''&date(Max(Week)-7,'MMM DD,YYYY')

[kaushiknsolanki]

Try this.

='Total Calls in Previous Week ( '&date(Max(Week)-7,'MMM DD,YYYY')&'-'& date(Max(Week)-7,'MMM DD,YYYY')

Regards,

Kaushik Solanki

[NavinReddy]

Thank you its woking

[NavinReddy]

Hi Kaushik,

sum({$<Week = {'>=03/24/13 <=03/30/13'}>}[Client Calls]),

sum({<Week = {">=$(=date(Max(Week)-7))<=$(=date(Max(Week)))"},Week=>} [Client Calls])

These two expressions giving differ ent results

second expression im selecting same month only

again different results,

plz help me

thanks,

rohith