Hi i would just like to ask If how can I make another column if I have these data. I have a date format in the column (yyyy-M-dd) I would just like to trim it through adding another column:
How to create another column (period column) using the raw field:
Date: Expected output (Period)
2020-02-24 01
2020-03-11 02
2020-04-10 03
Basically my period 1 starts from the month of february, then period 2 is march so on and so forth.
Solved! Go to Solution.
Hi @enkenmendoza ,
I have added some more dates to check if the formula works even if the month is January, which should return you Period =12
Hope that helps,
Angelos