mdatetime is already of type datetime. Why do you try to convert datetime to datetime?

This should work for you:

dw_1.find("mdatetime = DateTime(Date('2018-05-04'),Time('07:11:00'))",1, dw_1.rowcount())

Explanation:

The datawindow datetime function takes a date and optional a time argument: DateTime ( date {, time } )

If you use datetime function to convert a datetime column the argument is used as a date. So the conversion removes the time part! To check this try:

dw_1.find("DateTime(mdatetime) = DateTime(Date('2018-05-04'), Time ('00:00:00'))",1, dw_1.rowcount())

HTH,

René

Hi!

This question is important for me. I create a small example.

The first and second case is ok, the third and forth are fail  with DateTime datatype, and the fitth is correct with extra computed field and string conversion. 

How to compare datetime column?

Regard,

Géza. 

You could also create 2 computed columns that are the string values of your datetime columns (don't have to display them), then use those in the Find, so you're comparing string to string.

There are two issues with your code:

1. You've mixed up single and double quotes in a few places

2. you're trying to tell the Find Function to compare a date column to a string value, which won't work

To succeed, you need to convert the string back to a date using the Date() DataWindow expression function:

ll_row = dw_sheet.find("cu_curr_code='"+ls_curr_code + "' and cu_cle_code='"+ ls_cle_code + "' and value_date_from= date('"+ String(ld_value_from) + "') and value_date_to= date('"+ String(ld_value_to) + "')", 1, dw_sheet.rowcount( ) )

Note that the output of String(date) without a format string varies depending on your system settings and the date() function might not interpret it correctly. We generally use String(date, 'YYYY-MM-DD') for these purposes.