Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can you please explain the meaning of it::: AddMonths($(vDate), RecNo()) as Date,
ceil(rand()*1000) as Amount
AutoGenerate 36
Hi,
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
example
vDate= 01/01/2016
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..
Regards