Forum Discussion

RichJW's avatar
RichJW
Helper III
7 years ago
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]   ...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    RichJW

     

    You can use the format function for the concatenation:

     

    ConcDate = Tasks[ProjectName] & " : " & Tasks[TaskName] & " : " & FORMAT(Tasks[TaskStartDate] ,"dd/mm/yyyy")

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I have  asimilar issue. My dates are showing fine as dd/mm/yyyy but when concatenating it gets a dash iso slash dd-mm-yyyy
Applying a format function as suggested above did not work.

anybody an idea?