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
- In my SalesLogix Opportunity web group, I get the error: The Date entered in not a valid date. Year is not a 2…
- Do you think there is a performance penalty in SalesLogix for adding columns at runtime vs. having the SQL in…
- ISO Date Formatting
- Can I convert a field in the SalesLogix account table from being a Date/Time field to being a Date field?