Compare to today date with and column date

[Palaniyappan (Forum Leader)]

It seems like there is no such column named under 12 in your excel
Is it so
Cheers @Abubakkar

[Abubakkar (vnrabu)]

Thanks @Palaniyappan.
it’s working fine now. condition also working. now I can compare today’s date with excel column date. but I can’t delete further excel column name

[Palaniyappan (Forum Leader)]

Is col_index variable is getting incremented
Cheers @Abubakkar

[Abubakkar (vnrabu)]

No buddy. how can I increment col_index variable?

[Abubakkar (vnrabu)]

for your references

[Palaniyappan (Forum Leader)]

On what condition we are trying to delete the columns
@Abubakkar

[Abubakkar (vnrabu)]

for your references

[Abubakkar (vnrabu)]

Thanks @Palaniyappan

May I know what kind of error this ?

[Palaniyappan (Forum Leader)]

Fine
Either mention the column name or column index and if we mention both we will be getting this error
Cheers @Abubakkar

[Abubakkar (vnrabu)]

with this condition @Palaniyappan
if today’s date (12) and excel column name date (12) is same then i should delete columns with today from end of the month till.

[Abubakkar (vnrabu)]

[Palaniyappan (Forum Leader)]

Then assign the value of col_index as Cint(dt.Columns(dt.Columns.Count).ColumnName). Assuming that the columnName has only number as header and if so define this in the variable panel as default value for col_index variable

And try to delete from the last column to till date in reverse order
So the condition be like this in while loop
Cint(dt.Columns(dt.Columns.Count).ColumnName) > Cint(Now.ToString(“dd”))

Cheers @Abubakkar

[Abubakkar (vnrabu)]

Thanks for the response @Palaniyappan

is that correct ?

[Palaniyappan (Forum Leader)]

Yah let’s try
Cheers @Abubakkar

[Abubakkar (vnrabu)]

Getting error like this

[Palaniyappan (Forum Leader)]

@Palaniyappan

Cint(dt.Columns(dt.Columns.Count-1).ColumnName) .

It should be like count -1
And same in the below condition as well

@Palaniyappan

Cint(dt.Columns(dt.Columns.Count-1).ColumnName) > Cint(Now.ToString(“dd”))

[Abubakkar (vnrabu)]

no error buddy but output like this

[Palaniyappan (Forum Leader)]

Hmm fine but we from where does this false statement comes from
Cheers @Abubakkar

[Abubakkar (vnrabu)]

Here @Palaniyappan

[Palaniyappan (Forum Leader)]

So is it deleting the columns
@Abubakkar