Random date display.

[#1]

How to display random date which occurs for  next 365 days.

Thanks in advance.

[sunny_talwar]

Try this:

=Date(Today() + Floor(Rand() * 365))

EDIT:

or this in the script:

Date(Today() + Floor(Rand() * 365)) as FutureDates

[MK_QSL]

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;

[Kushal_Chawda]

Try,

Load

date(RecNo()-1+Floor(Today())) As Date

AutoGenerate(365);

[maxgro]

load

  date(today()+floor(rand()*365)+1) as next365date

AutoGenerate 1000;