Extract month from date

[vschowdary]

HI ALl,

I am having data like below,

Product, ID, date

APP,1,2021-12-10:08:42

mango,2,2021-12-10:05:45

grape,3,2021-12-09:06:35

orange,4,2021-11-10:05:12

bananna,5,2021-10-10:03:56

Now from the date column i want to get latest month date records.

Here latest month is December and for december we are having 3 records . i nned to all records for max month.

Can you please help me  on priority.

[vinieme12]

Fact:

Load Product, ID,date,Date(date,'YYYYMM') AS yearmonth

From Xyz;

Inner Keep(Fact)

Load 

Max(yearmonth) as yearmonth

Resident Fact;