How to compare the value in the column “Data validità” with Today?
I want to check if it is greater than today.
lets take like the above image gives us a datatable named dt
–now use a for each row loop and pass the above variable as input
–inside the loop use a IF condition like this
Datetime.ParseExact(row(“yourcolumnname”).ToString,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture) > Datetime.Now
if true it will go to THEN part or to the ELSE part
hope this would help you
kindly try this and let know for any queries or clarification
I would do a little change Datetime.ParseExact(row(“yourcolumnname”).ToString,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture) >= Datetime.Now.Date
Thank you so much @Palaniyappan.
I’ll try and let you know as soon as possible.
Cheers buddy @CamiCat
Tabella_input.Select("[Data fine validità DURC] < #"+DataOdierna+"#" Or [Data fine validità DURC] is NULL).CopyToDataTable
Which errore I’m inserting in this query?
The expression be like this
Tabella_input.Select("[Data fine validità DURC] < #"+DataOdierna+"# Or [Data fine validità DURC] = ‘’ “).CopyToDataTable
Thank you so much @Palaniyappan,
how to insert empty value in datatable datetime column?
this gives me error.
Colonna data non valorizzata: Exception has been thrown by the target of an invocation.
we can mention as String.Empty
were we facing any issues with this
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.