Getting YYMM fromat in string from excel need to compare it with current YYMM

Hi Guys,

Please help , I need to check if YYMM from excel sheet is less than or equal to current YYMM.

example:
2012 from excel <= 2101

Date.parse(“excel date”).to string(“yyMM”)<=Date.today.tostring(“yyMM”)

Getting error as below,

What is the format coming from excel can I have a example


Kindly check this.
Hope this helps.
(2012<=CInt(date.Today.ToString(“yyMM”))).ToString

thanks it worked that’s nice idea. :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.