Formatting a date

[slickp]

Hi, i have a formula below:

totext(dateadd("d",6,{table.date}-dayofweek({table.date})+1),"dd/MM/yyyy")

However i would like the date to formatted into say "02 January 2007" rather than "02/01/2007" which is what i've got. How can i change the formula above to show the date in the formatting i want.

Cheers

 

[satinsilhouette]

totext(dateadd("d",6,{DonHierarchyTest1_19.Effective Date}-dayofweek({DonHierarchyTest1_19.Effective Date})+1),"dd MMMM yyyy")

Thanks so much!
satinsilhouette

 

[synapsevampire]

Or don't bother converting it to text, just use:

dateadd("d",6,{table.date}-dayofweek({table.date})+1)

Now right click the field and select format field and select the format you'd like under custom.

-k