Date Format Error while using search method

[Marcel]

I have some business processes in which I use the search block to extract the data from the databases and then access the individual data records via a loop block for further processing.

Now I have noticed that in a data table in which I also use the date format, I only get NaN as output with this procedure for the date format after I use the expand date block.

If I use the getone method, I can extract the date normally.

Even if I pass the date as a date to a datepicker, for example, it seems to work.

Now I have the problem that with some displays in the web application, instead of the expected 2025-01-07(string), I now only get 2025-NaN-NaN. A few days/weeks ago, this was still working.

Is there a solution here?

[Basil_K]

Could you provide more details here including business process screenshots (frontend and backend)?
I tried to reproduce it from my side but everything looks correct and didn’t manage to get described error.

[Marcel]

yes. as a testcase i created following business process in backend:

[Marcel]

in front end I created the following business process to display the data:

[Marcel]

result in the connected text block:

[Marcel]

the data in backend contains normals dates:

[Basil_K]

Looks like some problem with expand date block, will be fixed.
Currently please replace 5 blocks from Expand date to Concat strings with single Date & Time to string block.
Format could be YYYY-MM-DD

[leryq_it]

Hello, @Marcel!
We’ve fixed the “Expand Date” block.

[Marcel]

i have already seen that everything works good now. great thx to you guys