Avoid time while Concatenate multiple fields with Date field in it
I'm trying to concatenate three fields, where one is Date field. but when I concatenate the date field,it is adding time with it.why is it happening?I just want to add date only. the Field is also Date not Date and Time.
Esrana Sikder commented
Thanks Derrick...got it correct
Derrick Kotlus commented
Great question! Even though it may appear to be just a date in TrackVia, it is also stored with a default time on our servers. When you reference this date field in a calculated text field, it is pulling the value straight from the server, therefore also returning the time.
If you want to just display the date without the time, you can wrap a snip function around it. See an example of this below:
This will snip from the beginning of the string to the space and cut off the time. Hope this helps, please let us know if you have any other questions!