Converting a String to Date and filter for the latest week

Question

I have a Date Column as below,

01MAR2023:00:00:00
01MAR2023:00:00:00
01MAR2023:00:00:00
01MAR2023:00:00:00
01MAR2023:00:00:00
01MAR2023:00:00:00

and need to convert this to a proper date column, after converting i need to filter the data for the latest week, My week start day is Wednesday and ends on Tuesday. If i run the workflow on coming wednesday 5th of april I need to filter the data from 29th march to 5th april ( latest week).

ShankerV · Answer

@kiotsuresh

1. Please use datetime tool to change the date to correct format.

2. Use the filter tool to filter the dates for the previous week.

Input used:

Note: The workflow will work dynamically when ever it is run on Wednesday it takes the previous week data's.

Many thanks

Shanker V

Converting a String to Date and filter for the latest week.yxmd