Forum Discussion
Solved
Concatenating Columns changes Date Format
Hi all, I have a simple function concatenating 3 columns (2 are text, 1 is in date format). ConcDate = Tasks[ProjectName] & " : " & Tasks[TaskName] & " : " & Tasks[TaskStartDate].[Date] ...
You can use the format function for the concatenation:
ConcDate = Tasks[ProjectName] & " : " & Tasks[TaskName] & " : " & FORMAT(Tasks[TaskStartDate] ,"dd/mm/yyyy")
You can use the format function for the concatenation:
ConcDate = Tasks[ProjectName] & " : " & Tasks[TaskName] & " : " & FORMAT(Tasks[TaskStartDate] ,"dd/mm/yyyy")
Wonderful, thank you themistoklis. That works a dream.