Remove hh:mm aa from label when given a date

I am pulling a date (not a datetime) from a DB and when I show that information in a label it shows in full MM/dd/yyyy hh:mm aa format. Being only a date it only shows 00:00:00 for the hh:mm:ss portion. How do I remove that from the label so that my final label shows only the MM/dd/yyyy?

If you’re binding the Text Property to a query (MySQL):

SELECT DATE_FORMAT(now(),"%m/%d/%Y") as Date

Option 2:

Use a custom property on your label. Then use an expression to bind to and format the custom property:


Thanks Jordan. The second example worked great.