Home
Troubleshooting and Tuning
Performance depends on many factors, including your database and web server configuration, network connectivity and other configurations.
Troubleshooting Guide
Stored Objects
Refer to this section for assistance in troubleshooting issues with stored objects, including derived fields, user variables, custom macros, and templates.
Using a derived field to output time in 24-hour format
Problem or error: How do I output time in 24-hour format (military time) in Unica Campaign?

Troubleshooting and Tuning
Performance depends on many factors, including your database and web server configuration, network connectivity and other configurations.
- Tuning Guide
- Troubleshooting Guide
  - Troubleshooting Unica Campaign Performance
    Performance depends on many factors, including your database and web server configuration, network connectivity, and Unica Campaign and Unica Platform configuration.
  - Using log files to troubleshoot
    These topics explain how to use the Unica Campaign log files for troubleshooting.
  - Unica Campaign Configuration
    These topics provide troubleshooting information about Unica Campaign configuration and integration.
  - Localization and Internationalization
    Refer to this section for assistance in troubleshooting issues with configuring Unica Campaign for use with non-ASCII data or non-United States locales.
  - Troubleshooting database issues
    Refer to this section for assistance in troubleshooting database issues for Unica Campaign system tables and user tables (data sources).
  - Unica Campaign Server and Utilities
    Refer to this section for assistance in troubleshooting issues with the Unica Campaign utilities.
  - User Administration and Security
    Refer to this section for assistance in troubleshooting issues relating to application access and user permissions.
  - Unica Campaign Interface
    Refer to this section for assistance in troubleshooting issues with using the Unica Campaign interface.
  - Processes and Flowcharts
    Refer to this section for assistance in troubleshooting issues with Unica Campaign processes and flowcharts.
  - Cell Management
    Refer to this section for assistance in troubleshooting issues with cell management, including target cell spreadsheets, cell codes, and cell code formats.
  - Contact History and Response Tracking
    Refer to this section for assistance in troubleshooting issues with contact history and response tracking in Unica Campaign.
  - Stored Objects
    Refer to this section for assistance in troubleshooting issues with stored objects, including derived fields, user variables, custom macros, and templates.
    - Using a derived field to output time in 24-hour format
      Problem or error: How do I output time in 24-hour format (military time) in Unica Campaign?
    - Custom macro Check Syntax button indicates error even when expression is valid
      Problem or error: When you create a custom macro expression and you click Check Syntax, you may see an "Invalid Expression" error. In some cases, this error appears even if the expression is a valid expression.
    - Use of random macro without a length argument profiles indefinitely
      Problem or error: If you use the macro function random() without a length argument, Unica Campaign generates as many random values as needed, but profiling this derived field never completes, because Unica Campaign does not stop generating random values.
  - Customizing campaigns
    Refer to this section for assistance in troubleshooting issues with customizing campaigns.
  - Installation and Upgrades
    Refer to this section for assistance in troubleshooting issues with installing and upgrading Unica Campaign.
  - Data Migration
    Refer to this section for assistance in troubleshooting issues with migrating and re-migrating data to Unica Campaign from pre-7.x versions of Affinium Unica Campaign.

Using a derived field to output time in 24-hour format

Problem or error: How do I output time in 24-hour format (military time) in Unica Campaign?

Solution: To obtain 24-hour time format you can create a derived field in Unica Campaign using the following statement.

if((string_seg(10, 11, Current_Time()) = 'PM' 
AND number(string_seg(1, 2, Current_Time()))< 12) , 
string_concat(format((number(string_seg(1, 2, Current_Time()))+ 12),2), 
string_seg(3, 8, Current_Time())), 
if ((string_seg(10, 11, Current_Time()) = 'AM' 
AND number(string_seg(1, 2, Current_Time())) = 12), 
string_concat('00', string_seg(3, 8, Current_Time())), 
string_concat(string_seg(1, 2, Current_Time()), 
string_seg(3, 8, Current_Time()))))

Note: This example assumes that the hours are formatted with a leading zero (01:01:53 PM and not 1:01:53 PM). The Windows operating system may not provide the leading zero, but UNIX does.

Here is an alternative method that achieves the same result.

StripHour = string_seg(1, 2, Current_time())
HourNum = number(StripHour)
StripPM = string_seg(10, 11, Current_time())
StripRest = string_seg(3, 8, Current_time())
if((StripPM = 'PM' AND HourNum < 12), 
string_concat(format((HourNum + 12),2), StripRest),
if ((StripPM = 'AM' AND HourNum = 12), string_concat('00', StripRest),
string_concat(Strip_Hour, StripRest)

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.