Mapping

Kalyani_Gaikwad
New 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
Regular Contributor

Re: Mapping

@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

ChrisHeathcote
Community Boss

Re: Mapping

@Kalyani_Gaikwad 

Create a custom time mapping as per below;

ChrisHeathcote_0-1624965713620.png

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

3 REPLIES 3
abhay.kanik
Regular Contributor

Re: Mapping

@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

ChrisHeathcote
Community Boss

Re: Mapping

@Kalyani_Gaikwad 

Create a custom time mapping as per below;

ChrisHeathcote_0-1624965713620.png

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

ChrisHeathcote
Community Boss

Re: Mapping

@Kalyani_Gaikwad 

Try the following selection;

ChrisHeathcote_0-1624965589206.png

Alternatively, you will need to amend you source data. 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA