Retrieve the rows which are created after 10 AM yesterday and before 10 AM Today in which date format is (MM/dd/yyyy hh:mm tt)

Hi All,

I’m trying the below ways -

  1. Converting the DateTime format using
    DateTime.ParseExact(datevar, “M/d/yyyy h:mm:ss tt”, CultureInfo.InvariantCulture)
  2. Using a SQL Query

Please put on your ideas on this on how this can be achieved.

Thanks in advance :slight_smile:

If its in Datatable - Filter datatable can be used.
With one Condition as date>“4/13/2020 10:00:00 00” and
date<“4/14/2020 10:00:00 11”

1 Like