|
| | | Junior Member
 
Group: Forum Members
Last Login: 8/30/2006 1:53:07 PM
Posts: 16, Visits: 56 |
| | When we run a report that includes the estimated close date field, we get the following error: Unable to convert field: 6075 in file: I:\PNTDATA\BORROWER\31063054.brw from value: 04/31/2006 to type: System.DateTime
String was not recognized as a valid DateTime. This is a little perplexing because Point automatically formats the field when the date is entered, so even putting in "4/31/06" results in "04/31/2006".
I would like to avoid deleting and re-creating the file if possible.
Thanks for any help or info!
----------
Have you backed up your data today? |
| |
| | | 
Sepal
Group: Moderators
Last Login: Yesterday @ 4:06:35 PM
Posts: 1,183, Visits: 9,261 |
| 4/31/06 is not a valid date. April 2006 only has 30 days not 31.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.  |
| |
| | | Junior Member
Group: Forum Members
Last Login: 8/30/2006 1:53:07 PM
Posts: 16, Visits: 56 |
| | Is there a :smacksselfinforehead: smiley kicking around somewhere? 
----------
Have you backed up your data today?
|
| |
| | | Supreme Being
Group: Forum Members
Last Login: 1/2/2009 6:24:50 AM
Posts: 111, Visits: 1,218 |
| | Don't feel bad... I've had to fix this exact same problem for 75% of my loan officers. You aren't alone. |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 4/17/2006 7:35:10 PM
Posts: 5, Visits: 16 |
| | Right. The reports generator is not very intelligent in this regard especially since the date picker already knows that April hath only 30 days, not 31 (click the Date icon). Why then does it let me type in 4/31/06? Not all of us remember which months have how many days. |
| |
|
|