Dear Forum,

In Gridview, I am concatenating 3 Fields types (Text / Number / Date), however my date field {Date} is appearing as a number. = 45376

Function used = CONCATENATE()

Question : How to show {Date} = 45376 = 3/25/2024 nested inside the concatenated formula or even to make another calculated field that converts the Formatted Date to TEXT, then I concatenate that field instead.

'H00006 - Tracy Ann Wright - 8764339605- 45376 - $1500

Desired Result
'H00006 - Tracy Ann Wright - 8764339605- 3/25/2024 - $1500

Thanks in advance for any suggestion. (My Brain hitting a Wall)