Thanks all. I put it in as below but get this error. ERROR: Execute error: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:522 cannot recognize input near 'yymmdd8' '.' ')' in select expression as SELECT DISTINCT t2.ac, t1.ext_ui, t1.vkonto, t1.vkbez as sap_name, input(t1.einzdat,yymmdd8.) as dateto format=ddmmyy10., input(t1.auszdat,yymmdd8.) as datefrom format=ddmmyy10. FROM analytics_temp_user.List t2 inner join analytics_pm6.ALLSAPDATA t1 ... View more

as SELECT DISTINCT t2.ac, t1.ext_ui t1.vkonto, t1.vkbez as sap_name, t1.einzdat as dateto, t1.auszdat as datefrom   FROM analytics_temp_user.List t2 inner join analytics_pm6.ALLSAPDATA t1 ... View more

Thanks. When adding it to my select statement in my program, do I replace where you put the actual date entered in the field with the field name ‘dateto’? ... View more