https://community.qlik.com/t5/Talend-Studio/How-convert-date-from-tLDAPInput-to-an-actual-date-format-yyyy/m-p/2218478#M13656 <P>Hi Guys</P><P>&nbsp;</P><P>Please assist.&nbsp;</P><P>&nbsp;</P><P>I am still new in Active Directory/LDAP.&nbsp;I am retrieving some user info from Active Directory, one of the column i am retrieving is accountExpires. Insted of getting an actual date format I am getting string with 18 digits(132380280000000000).</P><P>&nbsp;</P><P>How do I convert the 18 digit string into an actual date format (yyyy-MM-dd).</P><P>&nbsp;</P><P>Please Help!</P><P>&nbsp;</P> Sat, 16 Nov 2024 02:08:57 GMT vsitsula 2024-11-16T02:08:57Z https://community.qlik.com/t5/Talend-Studio/How-convert-date-from-tLDAPInput-to-an-actual-date-format-yyyy/m-p/2218478#M13656 <P>Hi Guys</P><P>&nbsp;</P><P>Please assist.&nbsp;</P><P>&nbsp;</P><P>I am still new in Active Directory/LDAP.&nbsp;I am retrieving some user info from Active Directory, one of the column i am retrieving is accountExpires. Insted of getting an actual date format I am getting string with 18 digits(132380280000000000).</P><P>&nbsp;</P><P>How do I convert the 18 digit string into an actual date format (yyyy-MM-dd).</P><P>&nbsp;</P><P>Please Help!</P><P>&nbsp;</P> Sat, 16 Nov 2024 02:08:57 GMT https://community.qlik.com/t5/Talend-Studio/How-convert-date-from-tLDAPInput-to-an-actual-date-format-yyyy/m-p/2218478#M13656 vsitsula 2024-11-16T02:08:57Z https://community.qlik.com/t5/Talend-Studio/How-convert-date-from-tLDAPInput-to-an-actual-date-format-yyyy/m-p/2218479#M13657 <A href="http://goliferay.blogspot.com/2015/11/convert-18-digit-ldap-timestamps-to.html?m=1" target="_blank" rel="nofollow noopener noreferrer">http://goliferay.blogspot.com/2015/11/convert-18-digit-ldap-timestamps-to.html?m=1</A> Mon, 15 Jun 2020 19:38:07 GMT https://community.qlik.com/t5/Talend-Studio/How-convert-date-from-tLDAPInput-to-an-actual-date-format-yyyy/m-p/2218479#M13657 akumar2301 2020-06-15T19:38:07Z