How to Convert Datetime value from lookup activity output to only a Date value into Set variable act

New Contributor

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.

1 Reply
i found the answer
@formatDateTime(activity('lookupactivity').output.firstRow.DWHModifiedDate,'yyyy-MM-dd')