Nov 23 2022 11:11 AM
Can you please help me in formatting the Lookupactivity Output value from Datetime to Date type and pass into set_variable activity.
Step 1: I am using a query in Lookup activity as SELECT CAST(MAX([DWHModifiedDate]) AS DATE) AS DWHModifiedDate FROM [Schema].[TableName]
The output from lookup activity is like "DWHModifiedDate": "2022-11-18T00:00:00Z"
Step 2: Now i added a Set_variable activity and i want to store only the date from Lookup activity output for example the variable value should be only "2022-11-18".
Can you please help how to achieve this.
Nov 23 2022 11:28 AM