Forum Discussion
pmscorca
Post Prodigy
2 years agoAdding a custom column to a copy activity
Hi, is it possible to add a custom column to a copy activity? I'd like to add a load date for each tables copied from a source to a destination, using the for each activity. Any helps to me, pleas...
- 2 years ago
Hi,
I've solved specified this column and the related expression:
@formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ss')
In the lakehouse the actual datetime column is created as a string/char type and not a date type.
pmscorca
Post Prodigy
2 years agoHi, but how specifying the actual date in the highlighted box?
pmscorca
Post Prodigy
2 years agoHi,
I've solved specified this column and the related expression:
@formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ss')
In the lakehouse the actual datetime column is created as a string/char type and not a date type.