I am using R5 and I have a field of date/time type.
after that want to retrieve the month and year value from that field
@month(field1) + @year(field1) but it failed
but when i try @month(@Now)) then is is okay
so i guess it is stored as a string.
I searched the help in R5 and it says CDat can be used
to convert String to Date but turns out R5 says it is invalid.