Is there a way to pipe just the date part of a field validated as datetime (e.g. M-D-Y H:M)?

If a date field in your project must be validated as datetime (e.g. M-D-Y H:M) but you need to pipe only the date portion without the time, you can do this using the @CALCTEXT action tag plus the "left" special function to return only the date portion without the time portion.

Below is a basic field with M-D-Y H:M validation:

Create a second field where you will use the 1) @CALCTEXT action tag plus the 2) "left" special function to to create the formula:

@CALCTEXT(if([datetime] <> "", left([datetime],10), ""))

This formula is saying that if the datetime field is NOT blank, return the first 10 characters of the datetime field. This will return the date in the mm-dd-yyyy format. Note that the M-D-Y field validations actually return mm-dd-yyyy format.

Now, when I enter data in the datetime field (1), the just_date field automatically returns the date without the time (2):

You can then pipe the date only to other locations in the project including the field label (1) and even set it as the default value in a field using @DEFAULT action tag (2). For example, if I build the field below:

It will output the date in field label (1) as well as the default value in the field (2):