Comparing a value of date to Date & time
Hello Team,
I have filter the date based on the function eomonth(today(),-1) i.e last day of previous month but the fitler has type of date & time where as this function will return only in date format.
I have tried to add the time to the function but couldnt able to achieve the requirement as it throwing error of miss comparison types.
please help.
Thanks in Advance.
Error : Expression evaluation error at function a!queryRecordType [line 3]: Cannot apply operator [LESS_EQUALS_THAN] to field [createdDate] when comparing to value [TypedValue[it=3,v=11/30/20236:08 AM]].
a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "createdDate" /* this is type of Date & Time */
operator: "<=",
value: concat(
eomonth(today(), - 1),
time(now())
)
),
},
ignoreFiltersWithEmptyValues: true
),
