What's new in Customer Journeys?

Connect and learn more!
How can I convert the date in User Login audit report to a YYYY-MM-DD format? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I convert the date in User Login audit report to a YYYY-MM-DD format?

Received Response
22
Views
2
Comments

Summary: User Login in the Planning (OCI) report exports the dates in this format, how do I convert it in Excel to something I can sort by or find the Max() of ?


Content (please ensure you mask any confidential information): The format of the date in the User Login report out of PBCS is not very usable, as I can't sort by it in Excel, nor find the last date a user logged in. Any ideas on how to convert it to something like 'YYYY-MM-DD' or a similar, sortable, format?


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!