Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to display random date which occurs for next 365 days.
Thanks in advance.
Try this:
=Date(Today() + Floor(Rand() * 365))
EDIT:
or this in the script:
Date(Today() + Floor(Rand() * 365)) as FutureDates
LOAD
Date(Floor(Rand() * 365 + Today())) as Date
AutoGenerate 10000;
EDIT
LOAD
Date(Today() + Floor(RAND()*(AddYears(Today(),1) - Today() + 1))) as InvoiceDate
AutoGenerate 10000;
Try,
Load
date(RecNo()-1+Floor(Today())) As Date
AutoGenerate(365);
load
date(today()+floor(rand()*365)+1) as next365date
AutoGenerate 1000;