Skip to Content
avatar image
Former Member

Date and Time assignment

Hello People ,

What is the format to be follwed while assigning date and time in date and time fields?Plz provide some examples.Thank You..

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 18, 2008 at 12:47 PM

    Hi Arnab,

    If you are talking about the literal date data type then the standard format is mm/dd/yyyy.

    But this can be converted to the desired format in the data manager.

    Hope it helps,

    Thanks,

    Minaz

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2008 at 01:02 PM

    Hi Minaz ,

    Thanks for the reply .but when write an expression in that format and apply the assignment its failing..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2008 at 04:47 AM

    Hi Arnab,

    MDM handles two types of Time

    - Literal Time

    - GM Time

    Literal Date and Literal Time fields are not corrected for the Time Zone of the MDM client application (e.g. a birth date and time, which are typically kept as (literal) times). By contrast, GM Time is a

    timestamp that can be adjusted by the user (or a client tool) to a specific time zone and is used for consistency across time zones (e.g.when a phone call was made, an order placed, or a record changed).

    When working with assignments we have to use the GM time expression as the time stamp fields displays the Time in GM time,So if you want to write an expression to track the time of updtaion of a record or track the time the record or field has changed from its original value use the std expression like systime(0) which refers to the surrent time .

    You can refer the following links to undesrstand how to design an assignment around this:

    syndicate-gm-time-as-local-time

    last-syndicated-time

    Hope It Helped,

    Thanks & Regards

    Simona Pinto

    Add comment
    10|10000 characters needed characters exceeded