Help with date handling

[grinder332518]

My table has a {start of year} date in the format “dd/mm/yyyy”.
I need to pick this up as ‘week1, and then add 7 days, for a whole year,
so that I can display :-
‘week2’, ({start of year} + 7 days)
‘week3’, ({start of year} + 14 days)
etc, etc, right up to ‘week52’.
Is there an easy way do this in FORMS, presumably with a date function ?
I don’t know VB very well.
Many thanks in anticipation…..

 

[namliam]

Search for and read up on the Dateadd function

 

[grinder332518]

thanks.
I came up with =DateAdd("d",7,[Start Of Year]) which seems to work OK

 

[grinder332518]

thanks.
I came up with =DateAdd("d",7,[Start Of Year]) which seems to work OK