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.