Hi everyone, Please help me find a solution for this problem. I extract from a website this value which is date but with a strange format (dd-MM-yyyy) : [image] I need to format this date and compare it in a if activity with the “today” date minus 60 days. I managed to find a solution with the …

Hi, Can you try the following condition? [image] DateTime.ParseExact(CellValueExtracted.Trim,"dd-MM-yyyy",System.Globalization.CultureInfo.InvariantCulture)>Today.AddDays(-60) Regards,

Date and Time format for extracted value

Help Studio

paul.baltag1 (Paul Baltag) November 30, 2022, 11:29am 9

Thank you very much. It works

Topic		Replies	Views
Date Compare Issue Activities excel , activities , question	30	5490	September 12, 2022
Convert 2 extracted values in a datetime variable and compare it with system month Studio studio , question , activities_panel	7	442	December 27, 2022
Extract date from string and apply condition Studio studio , question , activities_panel	10	101	July 10, 2024
Working with Date & Time Help activities , question , data_manipulation	8	4684	November 18, 2019
Extract dateTime Format as string Help	6	3001	July 12, 2019

Date and Time format for extracted value

Related topics