Getting Maximum Date using Aggregator, double to date how?

[smohd1338]

hi,

I have to bring the latest date from a table which has tis column.I used the aggeragator groping on dummy and pulled the maximum value, now the valuse by default is in double, but i need to palce it in the datetime feild ib the target table. I am using 8.1, there is no direct decimal to date conversion function, sow can i convert fron double to date format?

[chulett]

There should be an option in the Aggregator to 'preserve type' from what I recall, this to override the automatic output of a double.

[ray.wurlod]

The only real question is, is the Preserve Type property available in version 8.1?

If not, convert all your timestamps to seconds from an arbitrary zero point, aggregate them, and convert them back.

[priyadarshikunal]

I think I have seen this option since 8.0 so it should be there for 8.1