Date assignment in MDM..

[Former Member]

Hi,

I want to set litaral date field to 31.dec.9999 through assignments. How can we set this? I tried different options. But none of them gave expected result.

Thanks.

[former_member207367]

Hi Ramu,

As of i know, we can not change the literal data field format to your own format. we can acheive the conversion by using a text field.

Let me know if you need any help in that.

Regards

Sowseel

[Former Member]

Hi,

There is no option in setting format for literal date in console. My question is how can we set 31/12/9999 in literal date through an assignment?

[former_member207367]

HI Ramu.

You need to create a new field of type Text and then you can convert 01/12/9999 to 01-dec-9999 using assignments

There is no option format in any field properties of Literal Date. and also you can not convert the dates in to your own format on this field type.

Regards

Sowseel

[Former Member]

Hi Ramu,

Please write 3067670 in the assignment expression of the date field.

You execute the assignment and you will see the value as 12/31/9999.

Please try and let me know the result.

Regards,

Sravan

[Former Member]

Hi Ramu,

Did you try doing this?

Or u had some other solution.

Kindly let me know.

Thanks.

Regards,

Sravan

[Former Member]

Ramu -

the pre-requisite for setting this is to make sure that the date format is correctly set in the configuration tab in the console for the repo.

DD-MM-YYYY say

then have the same format date set in the assignment expression - then it should work

thanks

-Adrivit