Formatting date columns in a SalesLogix group

One of the questions I have been asked a couple of times is how to format dates shown in a group in the SalesLogix web client.  By default when you add a date time field to a layout of a group the date will display as something like “Tues Jan 16, 2001”.  To format it to be the standard short date format you can edit the column in the group layout and set the Format Type to “Date/Time”.  This will cause the date to display like “1/16/2001”.  In addition you can add a format string to the Format property of the column in the group layout.  To display just the time you can add hh:mm tt.  This would display just the time as “1:34 PM”.  If you want to display both date and time use ddddd hh:mm tt.

 

ABOUT THE AUTHOR

Kris Halsrud

Kris Halsrud is a Senior Analyst / Developer for Customer FX Corporation.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!