Date & Text formatting within one calculation

[AspenArchive]

I've put my 3.5 hours in trying to get this to work but can't - so here's my question: Is it possible to Text format a date calculation, yet still maintain control over the format of the date itself?

I have a calculation that changes the size of the text (of a date) if one thing and not the other, switching the field between 8pt and 9pt. This works when using the unformatted date "mm/dd/yyyy" but I would like the date to be "mm/dd/yy" and can't seem to format it this way unless it is a DATE calculation, yet the text calculations seem to be null. If I want the text calculations to be active, then it has to be a TEXT outcome for the calculation, but then I can't format the date to "mm/dd/yy."

Any solutions?

Thank you!!!

[-Queue-]

Try

Right( "0" & Month(dateField); 2 ) & "/" & Right( "0" & Day(dateField); 2 ) & "/" & Right( Year(dateField); 2 )

[AspenArchive]

Worked perfectly - I can't believe how amazing the help has been that I have received from this forum. Hopefully I'll be able to do the same for others as I continue to learn this stuff. THANK YOU.