Mapping

Kalyani_Gaikwad
Occasional Contributor

Mapping

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
abhay.kanik
Super Contributor

@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

View solution in original post

ChrisAHeathcote
Community Boss

@Kalyani_Gaikwad 

Create a custom time mapping as per below;

ChrisHeathcote_0-1624965713620.png

 

Chris
HeathcoteAndHerran.com

View solution in original post

3 REPLIES 3
abhay.kanik
Super Contributor

@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
Community Boss

@Kalyani_Gaikwad 

Create a custom time mapping as per below;

ChrisHeathcote_0-1624965713620.png

 

Chris
HeathcoteAndHerran.com
ChrisAHeathcote
Community Boss

@Kalyani_Gaikwad 

Try the following selection;

ChrisHeathcote_0-1624965589206.png

Alternatively, you will need to amend you source data. 

Chris
HeathcoteAndHerran.com