Skip to main content

Hello, can someone help me figure out how to add ONLY the Start Date to a field? Currently, it is adding both the Start Date and Start Time. See images for my current formula. Thank you!

Hi @Kelly_Smy


Take a look at the DATETIME_FORMAT() function here:



And the format specifiers you can use with it here:



You’ll just wrap the {Start Date/Time} part of your formula in the DATETIME_FORMAT() function.


It might be worth noting that you can simplify your CONCATENATE() formula can be simplified a bit by combining the literal string parts; ie,

" ", "-", " ",

could become just

" - ",


Thank you for that information. I hate to sound like a complete noob but I don’t quite understand when you that “I’ll just wrap the {Start Date/Time} part of your formula in the DATETIME_FORMAT() function”?


I tried adding the "DATETIME_FORMAT(‘YYYY/MM/DD’) after the {Start Date/Time} string but it came back with an #ERROR in the property field. I’m not sure where the DATETIME_FORMAT needs to go?



I fixed it, it worked. Thank you so much!



Reply