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 shared this idea · Dec 7, 2014
Comments
1 comment
Hello Esrana,
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:
snip({Date},""," ")
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!
Derrick
Please sign in to leave a comment.