GREATEST Function not working in E-Text template
Hi all,
I am using below Greatest function using in e-text template but not working. could you please help out.
TO_CHAR(greatest(Person_Eff_Start_Date,Assg_Eff_Start_Date,NVL(Pay_method_effective_start_date,to_date('01/01/1951','dd/mm/yyyy'))),'dd/mm/yyyy')
Thanks,
Ravikumar