Formula "Month" in a data source format ?
I have made a format on top of my data source.
I would like to create a new column that tells me how many days there are in a specific month.
I thought I could use a formula like:
if month(&Dato)=1 then 31 else if month(&Dato)=2 then 28 else etc.
But the formula "month(&Dato)" dosn't seem to work?
Anyone can spot what I've done wrong?