MAPPING TABLE DATE COMPARISION

[sai_12]

Hello everyone, 

I am trying to solve a problem for which i am using the following mapping code in load script

           [Map]:
         Mapping
         Load

         PrimaryKey,
         1 as Count

        from table_name
        (qvd)
         Where WildMatch(description,'CLIENT*','Work*')
         AND Date(Date_column,'DD/MM/YYYY')>YearStart(TODAY());

the field Date_Column is a datetime field, can some one help me to filter only those dates which is greater than yearstart of today that is 1/1/2023

[MayilVahanan]

hi

Try with floor function

Mapping
         Load

         PrimaryKey,
         1 as Count

        from table_name
        (qvd)
         Where WildMatch(description,'CLIENT*','Work*')
         AND floor(Date_column)> Floor(YearStart(TODAY(1)));

[BrunPierre]

Try.

Date(Floor(Date_column), 'DD/MM/YYYY') > Date(YearStart(Today(0)), 'DD/MM/YYYY')