${meta.current_timestamp!} in SpreadSheets

Hello,


I'm working on a new connection and I have a problem with ${meta.current_timestamp!} in the SpreadSheets I need to add the current time is this column but in the result I have the following error:


error in function Scripting: Can't convert the date-like value to string because it isn't known if it's a date (no time part), time or date-time value. The blamed expression: ==> meta.current_timestam(...)...



Here is my setup:


image


Thank you for any help


Nicolas


Hello Nicolas,


you have to specify wether the result is a Date, a Timestamp or a DateTime.

In this case it's a DateTime:

image


You can also add a ?string at the end to archive a specific format:

image


Kind Regards

Stefan