Page 1 of 1

Getting Maximum Date using Aggregator, double to date how?

Posted: Sun Jun 02, 2013 11:26 pm
by 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?

Posted: Sun Jun 02, 2013 11:27 pm
by 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.

Posted: Sun Jun 02, 2013 11:37 pm
by 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.

Posted: Tue Jun 04, 2013 1:17 pm
by priyadarshikunal
I think I have seen this option since 8.0 so it should be there for 8.1