Convert integer to date

DE_BYTEL

I want to extract the data for the last 6 months but I have a problem with the date format of my field.

On attachments you can see my column ANNEE_MONTHS and I want to convert this column to date format.

I try this but It can't works :

SELECT *, DATE_FORMAT(annee_months, "%Y/%m") as date_format

I try to use a prepare recipe with a "Format date with custom format" but It can't works (the screen is on the attachments).

I don't know how to proceed.

Catalina

To extract the date you should Parse to standard date format in the prepare recipe:

"Format date with custom format" can be used to convert the Date type to a string representation following a given format.

DE_BYTEL

Hi, thank you for your answer. I try this method in the prepare recipe and it works !