How do i convert datatable value to datetime format and filter via filter wizard

Hi All,

I just wanna check out i have an excel which was in the follow screenshot, i tried to convert it to date time and filtered via filter wizard activities

image

I have tried to convert it to date time but encounter the following error

image

image

Lastly if converted successfully i want to filter it to previous month Data only

hence i did this

however it does not filter correctly will someone be able to guide me on this

Thanks alot for the help

@beyondx Use Convert.ToDateTime(row.Item(“Transaction Date Time”).ToString,System.Globalization.CultureInfo.GetCultureInfo(“hi-IN”).DateTimeFormat).ToString(“MM”) and your filter will be the same as you had done

Hi Arpit, I have tried the above but still encounter this the format in excel is correct also no spaces in between

image

@beyondx
in your case it is recommended to take out some date values and test the parsing seperate to get it more clear.

In your samples you have dates like: 2/6/2020. For this the format is d/M/yyyy. In the hover over the validation issue we do see that you are parsing with dd/MM/yyyy.

So at this point start to do some analysis and error fixing

1 Like