Get Row Item - Not Accepting Date null value

Reading Date and Time from Excel using Get Row Item (var type- Date and Time).

Error;
If no Date assigned in Excel. Get row item Getting Error in Store null Value. Is there any other way to Store null value in Date and time data type.

Hi @SrenivasanKanna

Check the condition like string.ISNullorEmpty(row)

and assign row(“DateTime”).ToString=string.empty

Thanks
Ashwin S

@AshwinS2 Thanks ashwin.

Where should i give - string.ISNullorEmpty(row) in Propertites output or row item on Get row item Activity?

Hi @SrenivasanKanna

first check the condition in if activity and based on that in then condition use assign value for string.empty and else condition use get row item activity

Thanks
Ashwin S

1 Like

@AshwinS2

Thank you ashwin :slight_smile: