I need to select the date of some files in excel 48 hours before the end date
Datetime= DateTime.ParseExact(strdate,“dd.MM.yyyy HH:mm”,System.Globalization.CultureInfo.InvariantCulture).AddHours(-48)
Hope this helps you
I don’t get it to work, could you clarify it with an example, Thanks
error cuando realizo assign
Assign: String was not recognized as a valid DateTime.
Can you please share your string which you are passing?
I have several files with different end dates, I only need those from the last seven days, how can I do the if I had this one
End date> = Now.AddDays (-7) .ToString (“dd / MM / yyyy HH: mm: ss”), but it doesn’t work, could you help me, thanks
Your files date with time too or only date ?
can you please one file name here . If possible share screenshot
fecha finalizacion :02/03/2020 13:23:25
Fecha de finalización real
of these dates that you select from a web application we only need those that meet the following condition ended in a period less than or equal to 7 days, with respect to today’s date
Split the file name wrt to " : "
String.split(":"c)(1) gives you date part
assign to a variable
Put if condition and check whether its Less than or Greater than 7 Days.
I do not understand, please, the dates I need are the last week
I am asking to compare Today’s date with filename date . Find the diff between it and process the flow
Date difference can be found by
DateDifference = DateDiff(DateInterval.Day, Convert.todatetime(“03-10-2020”), Convert.todatetime(“03-22-2020”))
it will give you number of days.
If result is greater than 7 , its old one else its last week record
Also change DateDifference variable to Int64