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 ),
Discussion posts and replies are publicly visible
The concat() function turned the date and time values into a string. That will not work.
Instead, try to cast the date value into a datetime using the todatetime() function.
Thanks a lot Stefan..
Your always my timesaviour