Making a Custom Date Table in TERR

[Milton Sestito]

Hi,

I am new to TERR and was hoping to get some help on some very basic syntax on how to create a new table from scratch.

Essentially, I have a user-defined document property called "date_eff". This will be a date in the form of MM/YYYY. I would like to just create a script that makes a new data table with the column being Date beginning at the user-defined date,withrows housing data for sequentialmonthly time steps. Additionally, I would then like to do a second column that will function as a count of months (ie 1,2,3,4,5).

 

Basically for an example with say 5 defined rows to make it easy, if user enters 1/2021I'd like the following ouput columns with corresponding data:

Date Month

1/2021 1

2/2021 2

3/2021 3

4/2021 4

5/2021 5

 

I imagine this is a fairly straight forward calculation, but sometimes when you're learining from scratch figuring out syntax and the meaning of the errors can be a bit overwhelming so any help just to get started would be greatly appreciated. Thank you in advance!

[Fabian Duerr]

I hope that my screenshot is self-explaining:

[Milton Sestito]

Very straightforward and exactly what I had hoped for. I had brute force figured out how to do it a separate way using outside libraries, but this is much cleaner and concise. Thank you!