Date formatting in text fields

[yourbrain]

I have date fields where I applied custom formatting for the date to display as follows

Fri, 11 Nov 10 2006

But whenever I reference it in a text field it displays as 11/10/2006.

How do I make it display Fri, 11 Nov 10 2006 in the text field it is referenced?

Thanks in advance :P

[John Mark Osborne]

I'm not sure there is any way to reference the formatted date format through a calculation without writing an extensive formula. Why do you want to do this? There might be another solution.

[comment]

The easy way is to use a merge field instead. If you absolutely need to have it in a calculation, you will have to do the formatting as part of the formula, e.g.

Left ( DayName ( Datefield ) , 3 ) & ", " & Left ( MonthName ( Datefield ) , 3 ) & " " & Day ( Datefield ) & " " & Year ( Datefield )

[yourbrain]

thanks comment, this is exactly what I needed :P

[The Shadow]

If you're using 8.5, you can also use a calc like:

GetLayoutObjectAttribute( "dateField"; "Content" )

where you've named your layout object "dateField" to get the date with all the formatting preserved.