Date format turns into string when using groupbycategory or pivot

When using the groupbyperiod function or creating a pivot using a date column and applying keys function, the date variable is no longer read as date. While the month and year can be extracted, the day cannot be extracted. Eg: if my date is 7-5-2021, the pivot and groupbyperiod converts the date to 7th May 2021. Due to this I had to create multiple variables. Can you provide a solution for this?

Hi @KayVee,

This is the expected behaviour of the function, since it returns values based on the period that is chosen(month → January-2020, week → Wk1-2020, etc.). These can directly be used in filters as values if that is what the date is required for.