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.

2012 from excel <= 2101

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

Getting error as below,

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

Kindly check this.
Hope this helps.

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.