Date and Time assignment

[Former Member]

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..

[Former Member]

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:

Hope It Helped,

Thanks & Regards

Simona Pinto

[Former Member]

Hi Minaz ,

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

[Former Member]

Hi Arnab,

I dont know what exactly you are trying to achieve.

But for date manipulations you can refer to the below links.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b025fab3-b3e9-2910-d999-a27b7a07...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/102dc4e5-07c9-2910-93b3-f49c8ed5...

Hope it helps.

Thanks,

Minaz

[Former Member]

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