Home

Macros and Programming

 

CardboxForumsMacros and Programming > "Cardbox & Dates"

Cardbox & Dates

How do I get cardbox to add 6 months to a date already in a field, then input this to another field?

Current user: [none]
Register / Log In · Help

Posted By Post

batnip

7-Nov-2005 19:22

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:

Fields("b")=DateToCardbox(now+x)

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'.

Thanks, B.

Paul Irvine

8-Nov-2005 13:30

Fields("b")=DateAdd("m",6,Fields("a"))

Takes the date from field 'a', adds 6 months and sets the field 'b' text

batnip

8-Nov-2005 14:33

Thanks very much - I was but a pair of brackets away (well, almost anyway)! Cheers, B.

Quick Reply

Please log in or register before trying to post a reply.

 
© 2010 Cardbox Software Limited   Home