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:
1234 2016-12-13 00:00:00.000
3456 2016-12-14 00:00:00.000
5678 2016-12-15 00:00:00.000