Remove hh:mm aa from label when given a date

Ignition
1

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?

2

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

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

3

Option 2:

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

dateFormat(customProperyName,“MM/dd/yyyy”)

4

Thanks Jordan. The second example worked great.