Use Select in a DataTable using 2 conditions on the same Column

robot
#1

Helo, this is may first time.

i am tring to select dates in a DataTable with only one column of dates. I need to select dates between two dates. I try to use the next expresion in an assing activity, but it doesnt work. If I do de Select only with one condition, works fine, but i need the selection of a range of dates.

Column name is ‘Fecha’
hasta is variable type DateTime
desde is a variable type DateTime
EstractDTFecha is DataTable

ExtractDTFecha.Select(“Fecha<’”+hasta.ToString(“dd/MM/yyyy HH:mm:ss”)+"’ AND Fecha>’"+desde.ToString(“dd/MM/yyyy HH:mm:ss”)+"’")

Regards in advance

#2

Hi @JH76,
When comparing DateTime types, try writing as follows.

ExtractDTFecha.Select(String.Format("[{0}] < #{1}# AND [{0}] > #{2}#","Fecha", hasta, desde))
Regards.