I have tried different data type and so far out of luck. So I believe
I may miss something.
I created a list and I would like to have a view to show only current
month records. So, I added a calculate column to retrieve month and
year value from Created column in Month(Created) & Year(Created)
fromat.
Then I created a view with a filter applied. The filter is having the
calculated column equal to Month(Today) & Year (Today).
However, it will not return any records unless I change the criteria
to Is Less Than and it means the criteria are not equal to the column
value.
I changed the column data type to number or text, add Text or Value
function to filter or calculate column and none of them worked.
Any suggestions?