Format date?

[lespaul]

I have a TDate variable that I set to TODAY. I'd like it to be in MM/DD/YYYY format (it's currently returning M/D/YYYY and I need the 2 digit Month and Day). How can I force the date to the proper format?

Thanks!

Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned

 

[mikeEd]

As a string?

FormatDateTime('mm/dd/yyyy', date)

 

[lespaul]

Thanks! Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned