Formatting a Dynamic Window Title to use a specific date format

[#1]

Trying to configure a window title to dynamically render the date in a MM/DD/YYYY format, but still displaying the numeric value for the date.  I'm using the following expression that works for another window:

=max([POS Date]) & 'Position Data Details-On-Demand'

Any thoughts on what I need to do to get the date to display 12/31/2014?

[buzzy996 · Accepted solution]

try this,

=max(date#([POS Date],'MM/DD/YYYY') & 'Position Data Details-On-Demand'

[#3]

Shiva,

Thank you.  That worked.