Standardize date from another date columm

Hello mates,

I'm trying to create a Calculate columm using date, I know the fuction DATEADD might help me, but I don't know how to use it.

for Exemple, I have a columm with many different dates but I want to replace all days to 1st in a new columm .

Date: 20/04/2022 replace day to 01/04/2022
Date: 31/08/2022 replace day to 01/08/2022

somebody know how can I do this?

Hi @varsantos
Without knowing which database type you're using, then it's difficult to help. Try looking in your database documentation.
Post "Diagnostic Info" from Admin > Troubleshooting, and the database type you're querying.

Sorry I didn't get it

But exist a fuction for this? Like excel for exemple

date(day(1);Month(Date_table);Year(Date_table) ??

@varsantos You are looking for functionality that Metabase currently cannot do in the GUI. You would have to do that in SQL. How, I cannot tell you, since you haven't told which database type you are querying.

ahh, It is type "timestamp"

@varsantos I'm asking which database type you are using. Metabase supports more than 20+ different database types, which all uses very different syntax for SQL: https://www.metabase.com/docs/latest/databases/connecting#connecting-to-supported-databases

I found it,

Is Possible use the function DATE_TRUNC

to standardize all date I can write: DATE_TRUNC('month', name of columm with timestamp');

and all date will start with 1st.