month and year

ahmad4altamimi
Level 2
month and year

hello guys , i have problem , when i parse my date they will give me number of date only 

 

i dont know which month is 2024 or 2023 , like pic Screen Shot 1445-02-01 at 12.21.11 PM.png

0 Kudos
2 Replies
JordanB
Dataiker

Hi @ahmad4altamimi,

What is the output that you are looking for here? This is how date elements are extracted (with the "extract date elements" processor):

Screenshot 2023-08-17 at 4.21.17 PM.png

https://doc.dataiku.com/dss/latest/preparation/processors/date-components-extract.html#extract-date-...

Thanks!

Jordan

โ€ƒ

0 Kudos
me2
Level 3

Agreed.  If you need to know the year within the month than one way to do it is a prepare recipe that concatenates the year and month column.

Caution the output column will now be a text column.  Depending on what you want to do with it could impact future filtering, sorting and other functions.