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).
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