Getting Maximum Date using Aggregator, double to date how?
Posted: Sun Jun 02, 2013 11:26 pm
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?
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?