How can I generate random dates in a date field from a specific year in a table?

[jblomqvist]

Hi all,

How can I generate random dates in a date field from a specific year in a table?

For example I might have a table with 5,436 rows and I would like a date to be generated for each row in a Date field.

The dates have to be from a specific year (i.e. whatever year a user specifies). E.g. 2013.

How is this possible in QlikView please?

[jblomqvist]

Hi Sunny,

Does that mean it will look no more than 30 days ahead?

[sunny_talwar]

Yes, but that you can change based on your actual requirement

[jblomqvist]

Great I will change it to 45 or something.

Have a good day and thanks