R rynorem Registered User. Local time Today, 17:55 Joined Jan 9, 2006 Messages 27 Mar 5, 2006 #1 I have a date in the format of 01-NOV-05. In the criteria how can I get it to add 6 months to that date. Maybe I need to go back to school but can't figure it out for the life of me. Please help.
I have a date in the format of 01-NOV-05. In the criteria how can I get it to add 6 months to that date. Maybe I need to go back to school but can't figure it out for the life of me. Please help.
M Mikk Registered User. Local time Today, 22:55 Joined Mar 5, 2006 Messages 23 Mar 5, 2006 #2 Not too sure exactly but i'd try ([location of date goes here]+00/06/00)
R rynorem Registered User. Local time Today, 17:55 Joined Jan 9, 2006 Messages 27 Mar 5, 2006 #3 Overflow Thanks, Mikk for the response. The date is in the ADV E4 TBL so I put this: ([ADV E4 TBL.DOR]+0/6/0) and get an overflow error. That's new to me.
Overflow Thanks, Mikk for the response. The date is in the ADV E4 TBL so I put this: ([ADV E4 TBL.DOR]+0/6/0) and get an overflow error. That's new to me.
R raskew AWF VIP Local time Today, 16:55 Joined Jun 2, 2001 Messages 2,731 Mar 6, 2006 #5 Hi - As Rich pointed out, the DateAdd() function is the way to go. Example: x = #01-Nov-05# ? format(dateadd("m", 6, x), "medium date") 01-May-06 Bob
Hi - As Rich pointed out, the DateAdd() function is the way to go. Example: x = #01-Nov-05# ? format(dateadd("m", 6, x), "medium date") 01-May-06 Bob
