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)
_________________________
Edward C Chin-Mook
10 Waterloo Ave, Kingston 10, Jamaica
876-754-7444
876-754-5513