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

@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

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