Hello Andreia,
Please try this.
date(
_make_timestamp (cast(substr( Test_Date,6,4),integer),01,cast(substr( Test_Date,0,2),integer))
)
I made a dataitem Test_Date with the string value '01 | 2022'
------------------------------
Udaya Rani Palli
------------------------------
Original Message:
Sent: Tue November 21, 2023 06:30 PM
From: Andreia Siqueira
Subject: convert string to date
Hello,
I'm using the data module to organize some tables and I need to convert a column with string values to date, how can I do this using extract or cast or another function, this is an example of the value I need to convert.
------------------------------
Andreia Siqueira
------------------------------