I am facing problem with mapping. In sheet 20 jan month name, in grid view jan 20, so facing problem with time mappaing.
Go to Solution.
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.
View solution in original post
Create a custom time mapping as per below;
Try the following selection;
Alternatively, you will need to amend you source data.