u_account_expire date format

asd22
Tera Contributor

Hello, i have this field u_account_expires on sys_user wich format im unsure what is. But what i want is a field that displays this information in a readable format for users. So i can add the field to our portals "my page" so they can see when their it user expires.

asd22_0-1738762637139.png

 

Any tips on how to achieve this?

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@asd22 

this is custom field so you should check with the developer who created this and why he/she created it as string or integer type.

How is the data getting populated to that field? Identify that

I believe it's this date 2078-12-31 in YYYY-MM-DD format.

Is that a data source or LDAP etc?

If yes then what that number represents and handle the mapping correctly

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@asd22 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@asd22 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

hey i cant edit this fields type, i need to make another field that takes the u_account_expires information and displays it in a more understandable manner. This must be done with  ascript yes?