I have two fields, field 'a' contains a date (formatted in the normal way using Cardbox's validator, this data is inputted manually) and another, 'b' that I need to put a date into, this needs to be the date from field 'a' plus 6 months. The format in field 'b' doesn't need a day - just month and year is fine.
Can anyone help? I'm sure this isn't too difficult (except for me!)
I can add days to today's date using the line:
where b=field b and x=number of days, but I'm struggling with getting the data from field 'a' adding 6 months to it and then putting it into field 'b'.