Date format in formula

[jerryr125]

Hi - 

I have the following statement :

=if( IsNull(GetFieldSelections(DATE)),' ',[DATE.autoCalendar.Date] )

When the selection is not null, it displays the date as a number.  How do I modify the formula above to display the date as WWW - MMM/DD/YYYY  ??

Thanks - jerry

[imrasyed]

Try something like this 

=week(today()) & ' - ' & Date(Today(),'MMM/DD/YYYY')

[jerryr125]

If this is the formula - what do I add  to get the date to change to DDD - MMM/DD/YYYY ???

=if( IsNull(GetFieldSelections(DATE)),' ',[DATE.autoCalendar.Date] )

thoughts ?