Mapping

[Kalyani_Gaikwad]

I am facing problem with mapping. In sheet 20 jan month name, in grid view jan 20, so facing problem with time mappaing.

[abhay.kanik · Accepted solution]

@Kalyani_Gaikwad 

while import you can set the format of time to custom time format, make it  YY MMM for your case and it will map automatically.

If its a line item then also in line item mapping you will see a small edit option next to date formatted line items where you can set the same.

Thanks

Abhay

[ChrisAHeathcote · Accepted solution]

@Kalyani_Gaikwad 

Create a custom time mapping as per below;

[ChrisAHeathcote]

@Kalyani_Gaikwad 

Try the following selection;

Alternatively, you will need to amend you source data.