Can you please explain the meaning of it::: AddMonths($(vDate), RecNo()) as Date,
ceil(rand()*1000) as Amount
this script generates 36 lines, on each line it generates a Random amount and a Date.
it starts with a date which is the variable vDate
this script willgenerate a date for each month on 3 years ending to 01/12/2019
Understand your script line by line
addmonths() - > this function is use to add / deduct months from date.
ceil() - > it is rounding function
rand() 0 >generate random number.
AutoGenerate -> use to loop with end condition.
for more detail see help menu..
Retrieving data ...