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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.