Calculating a Date Lag

[Mikydisco]

HI there,

I have a dataset that contains a date 'dd/mm/yyyy' and a timelag indicator eg; '1' = 1 day after the date specified in the record, 2= 2 days after the date specified in the record etc, etc.

I'm trying to calculate what the 'lag date' would be utlising the original date and the timelag indicator.

Hoping someone can assist.

Many thanks

 

[allan57]

check out the dateadd function in vb help

 

[namliam]

Just add the lag indicator to the date field. If the Lagindicator is a number field (integer, long or double doesnt matter) and the date field is an actual date, that should work.