Format Date in String

[mtownbound]

I need to format a date field in my formula field. I'm running a mimimum, maximum to placed in the report header, something to the effect of:

"Date Range: " + ToText(Minimum({Database.Date Field}))
"to " + ToText(Maximum({Database.Date Field}))

The only snag is that the date is being displayed as the default "7/13/2011 12:00AM", but I need to see "7/13".

Any ideas??


Thanks!!!

 

[IanWaterman]

For 7/13

totext({Sheet1_.Posting Date}, 'M/dd')

For 07/13

totext({Sheet1_.Posting Date}, 'MM/dd')

For 7/13/2011

totext({Sheet1_.Posting Date}, 'M/dd/yyyy')

Ian

 

[mtownbound]

Worked great.

Thanks!!!