SOLVED
Troubleshoot conversion errors
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
david20100
8 - Asteroid
‎06-07-2018
06:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Error Message
3 REPLIES 3
Nate1
8 - Asteroid
‎06-07-2018
06:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
7 - Meteor
‎06-07-2018
06:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
7 - Meteor
‎02-25-2019
12:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is the right thing to do, I had a similar challenges was able to find the specific records by using Select Record Tool.
