https://community.qlik.com/t5/Water-Cooler/Date-Time-Format/m-p/2082104#M13412 <P>Hi,</P> <P>You can try with :</P> <LI-CODE lang="markup">=date(Field,'DD/MM/YYYY hh:mm:ss')</LI-CODE> Fri, 09 Jun 2023 10:07:23 GMT sergio0592 2023-06-09T10:07:23Z https://community.qlik.com/t5/Water-Cooler/Date-Time-Format/m-p/2080525#M13400 <P>Hi All,</P> <P>Need to add audit column as datetime in qlik replicate , howto get date format as dd/mm/yyyy hh:mm:ss</P> <P>Thank you,</P> Tue, 06 Jun 2023 09:53:50 GMT https://community.qlik.com/t5/Water-Cooler/Date-Time-Format/m-p/2080525#M13400 TTH1 2023-06-06T09:53:50Z https://community.qlik.com/t5/Water-Cooler/Date-Time-Format/m-p/2082104#M13412 <P>Hi,</P> <P>You can try with :</P> <LI-CODE lang="markup">=date(Field,'DD/MM/YYYY hh:mm:ss')</LI-CODE> Fri, 09 Jun 2023 10:07:23 GMT https://community.qlik.com/t5/Water-Cooler/Date-Time-Format/m-p/2082104#M13412 sergio0592 2023-06-09T10:07:23Z