CONCAT with date

Hi @Daniel Diers,

you have to both formats to be of the same data types. Probably you simply have to transform the data into a STRING. If you have already tested some PQL statements to do that, it would be great if you could share them here and we work on them together!

Best,

Justin

Hey Daniel,

you cannot apply a filter directly into an aggregation such as FILTER COUNT() > 5 but you can use pull-up functions.

You can use a similar example provided below

FILTER PU_COUNT_DISTINCT("ParentTable", "Table"."SupplierName"||

TO_STRING("Table"."Date", FORMAT ( '%m-%d-%Y, %H,%M,%S' ))

) > 5;

Best,

Gabriel