Hi,
after a scraping, I collect dates from a web page, conformed: “MM.dd.yy”. I have to compare this date if it is less than or equal to today, but the verification must be done only on month and year.
Then if MM/yy (of scrap) < today (MM/yy)
how should the string be inserted? The collected date is in DateTime format.
You should convert it to date and compare date by a month or year by
VariableDate.month < now.month
or VariableDate.year < now.year
Check date is less than or equal to today condiion
(checkdate.Year < now.Year or (checkdate.Year = now.Year And checkdate.Month < now.Month)) or (checkdate.Year = now.Year And checkdate.Month = now.Month)
Hello Aaron,
In this video I do a lot of stuff with String and DateTime:
0:35 Examples for Substring functions
4:10 IndexOf and LastIndexOf
5:00 SubString working together IndexOf and LastIndexOf
6:45 Split string by character
8:50 Split string by string
12:00 Lower Case and Upper Case
12:45 Trim
15:05 Compare strings in multiple ways
19:05 Resume of all the String function part
20:05 DateTime to string in multiple ways
23:00 AddDays get DayofWeek
25:40 Convert from String to DateTime
26:20 Compare DateTime
hi, tried with this but getting an error. i wants to check the month and year is future or not, if it is future then remove the data from excel. how can we achieve this?