Troubleshoot conversion errors

[david20100]

HI,

I have a Date Table 

Date	Fiscal Year	Fiscal Month	Fiscal Month2	Fiscal Month3	Fiscal Month4	Fiscal Period	Fiscal Day	CalYear
	1900	1	Janvier	Jan	January	05	0	1900
2004-09-01	2005	9	Septembre	Sep	September	01	1	2004
2004-09-02	2005	9	Septembre	Sep	September	01	2	2004
2004-09-03	2005	9	Septembre	Sep	September	01	3	2004
2004-09-04	2005	9	Septembre	Sep	September	01	4	2004
2004-09-05	2005	9	Septembre	Sep	September	01	5	2004

And when i join that table with my invoice table on Date, i got this conversion error

How can i go see record #328751 to see what is happening?

thanks

[Nate1]

You can use the Select Records tool. Just enter the record ID in the configuration and it will pull back just that record for you.

[DriveMyData · Accepted solution]

Hi David,

If you put a browse on your input tool, you will get numbers listed down the left hand side of the browse output. You will then be able to find your record.

Joe

[anoopdk]

This is the right thing to do, I had a similar challenges was able to find the specific records by using Select Record Tool.