Email Notification with date field

[Former Member]

Hi,

i marked the a field as Display field this way it is displayed in the Email notification. (%Records%).

But i can see the letral date field displayed in email as 2010:03:09:00:00:00:000

Why is the ''00:00:00:000'' displayed when i have a date field??

Did anyone face this issue..

KR

John

[Former Member · Accepted solution]

HI John,

Date field in MDM is 18 characters long and has date as well as time component to it.

You can use assignment to trim this and transfer its value to another field and make that field as DF,so that it is displayed in the mail as date.

Otherwise you can also create a calculated field for this purpose.

Please go through this very useful link to create expressions/validations with dates:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b025fab3-b3e9-2910-d999-a27b7a075...

Thanks,

Ravi

[Former Member · Accepted solution]

Hi,

But the Field is of Type Literal date which means Omits the Time!!!

KR

John

[Former Member · Accepted solution]

HI John,

Yes you are right.

I guess what is happening is the Literal date is only sending the date component but in mails it is getting auto converted to Text format,and so 00.00.00 gets appended to the field value.

The below mentioned is the format of date in text format:

Text Static text with u201C:u201D separators. The date is now a string and

allows for alphanumeric sorting.

2007:05:06:09:43:04:000

To resolve this you can trim the appended characters.

Thanks,

Ravi

[Former Member · Accepted solution]

Hi,

thats right.

But how can i write a validation to remove '00:00:00:000' from 2011:09:19:00:00:00:000.

I moved the literal date fied to a text field and i can see 2011:09:19:00:00:00:000.

Now i need to remove the '00:00:00:000' from this date, How can we do this , I think we dont have 'replace' function in MDM assignment!!!

KR

John

[Former Member · Accepted solution]

HI John,

Write expression using TRIM function in Data Manager assignments.

Let me know in case of any query.

Thanks,

Ravi

[Former Member · Accepted solution]

Hi John,

Now i need to remove the '00:00:00:000' from this date, How can we do this ,

This can easily be done using LEFT() Function. It (2011:09:19) include total 10 characters, so please use the below expression.

LEFT(Field name, 11) where field name is your literal date.

Note: Trim function will not work here as it only trim extreme spaces only.

Kindly revert with result.

Regards,

Mandeep Saini

[Former Member · Accepted solution]

Hi John,

Yes I agree with Mandeep LEFT function is appropriate here.

Syntax:

String Left Returns the specified

number of characters from

the start of a string

LEFT(F_name, n)

n specifies how many characters to return from F

I guess n=10 is right here.

Thanks,

Ravi

[Former Member · Accepted solution]

Yes, that worked, thanks a lot.

KR

John

[Former Member · Accepted solution]

This message was moderated.