mapping into LiteralDate field

[Former Member]

Dear Experts

My scenario is as follows -

Repository: Products

Requirement: Check if a product is expired or not based on the expiry date field of a product record.

The expiry date is a LiteralDate type field. I created a boolean calculated field which calculates this date and changes the value as valid or invalid.

However I'm facing a problem of mapping these LiteralDate fields individually while creating the import map. This isn't practically feasible.

1. Can I use any other field apart from LiteralDate to do the calculation?

2. Should the import records have date values in a specific format for importing into LietarlDate fields?

3. Is there a workaround for this?

Regards

SwarnaDeepika

[former_member207367 · Accepted solution]

Hi Deepika,

Please check the below thread

Hope this helps

Regards

Sowseel

[former_member188878]

Dear Swarna,

As far as my understanding you are trying to Map the Expriy date ,but you have also mention the Calculated field.

Please clarify which field your are trying to Map.

regards

shankar

[Former Member]

Hi Sowseel & Shankar

Thanks a lot for the quick response.

@Sowseel

I checked the date format in Configuration->Options. It was in the mm/dd/yyyy format. I updated the date field values in my import file to be in the same format. BINGO...everything is mapped automatically. No manual intervention.

Awarding full points...

Regards

Deepika