Help with SQLDate

General
1

Hi. I’m having a little problem with SQLDate. I want to show the date 14 days in advance of a date in a table. Thought this should be pretty easy, but it’s not acting the way I’d hope. I threw in a few different records for DateAdded (2013-02-01, 2013-07-01, 2013-09-02). The result is coming up like this (2013-10-15, 2013-10-15, 2013-10-16). So it seems like it’s only advancing 14 days from today, or whatever the day is set at.

dim d14 as new date d14.Day = DateAdded.Day + 14 day14.Text = d14.SQLDate /// just to see what the result is

Can someone offer some guidance please?

2

dim d14 as new date d14.Day = d14.Day + 14 day14.Text = d14.SQLDate /// just to see what the result is

3

Thanks Frederick. But won’t these just show 14 days in advance of today? I have a table with a field called DateAdded, which shows the date a user was added to the table. So I want the day14.Text to show me 14 days ahead of the date they were added. In my test data, I added some on 2013-09-29, but the day14.Text is showing a result of 2013-11-13 (14 days in advance of 2013-10-29)

4

DateAdded = (DateAdded.Day + 14)

5

DateAdded.Day = DateAdded.Day + 14 day14.Text = DateAdded.SQLDate /// just to see what the result is

6

Oh great! Thanks for your help!