Conversion of Date

[marco_puccetti]

Hello i need to create a calendar to navigate the date contained in the tables.

Is it possible to create this using this approach:

1) Compute the max date;

2) Compute the min date;

3 Create the calendar using the autogenerate from the min date to the max date, increasing the numeric version of the date each row generation.

As regard as the step 3 i need a function to convert a Simple data in the form dd-mm-yyyy to an integer value.

Using this

load

    Date($(m_rif_date_min) + RowNo()-1) As DT_RIFERIMENTO

    autogenerate($(m_rif_date_max)-$(m_rif_date_min)+1);

It doesn't work.

Thanks

Marco

[marco_puccetti]

Thanks

Marco