AnsweredAssumed Answered

Is it possible to increment a datetime column using the STIMESTAMP variable

Question asked by ThanNguyen82306198 on Dec 14, 2016
Latest reply on Dec 19, 2016 by ThanNguyen82306198



Is there is a way to increment the system timestamp variable based on the number of table repeat count I put in?  For example, I have a FileDate column that is a datetime field, and I would like the date to increment by 1 day for each table repeat count used. I looked through the Functions and Parameters page to find a function for this purpose but am not able to figure out which one would work since the field does not accept any function that is not date time.  The STIMESTAMP is perfect variable for this column however, I would like for that data to increment instead of staying static.


Here’s the sample data I’d like to generate if I use a table repeat count of 3:


Table A

LoadNum            FileDate

1234                       2016-12-13 00:00:00.000

3456                       2016-12-14 00:00:00.000

5678                       2016-12-15 00:00:00.000


Thank you,