Forum Discussion

RichJW's avatar
RichJW
Icon for Helper III rankHelper 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")

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

RichJW

 

You can use the format function for the concatenation:

 

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

  • RichJW's avatar
    RichJW
    Icon for Helper III rankHelper III
    7 years ago

    Wonderful, thank you themistoklis. That works a dream.