Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Refresh solved the issue.
Thank you
expression
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
arkiboys
9,711
Reputation points
Hello,
I am working in a DerivedColumn - column pattern expression
my sourceformat is: yyyy-MM-dd hh:mm:ss
do you know why the expression below shows as null in data preview?
whereas I am trying to see the date formatted as dd/MM/yyyy
Azure Data Factory
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator2021-11-10T02:42:27.807+00:00 Hi @arkiboys ,
Thanks for using Microsoft Q&A !!
Can you please provide a bit more details like what exactly you are trying to do ? Also, are you doing lookup on a Cache sink ?
Thanks
Saurabh
Sign in to comment
1 answer
Sort by: Most helpful
-
arkiboys 9,711 Reputation points
2021-11-10T05:31:34.397+00:00 -
Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
2021-11-12T19:21:26.85+00:00 Thanks for the confirmation @arkiboys .
Thanks
Saurabh
Sign in to comment -