I have a date field that is showing dates in the following format: 1/9/2006. I need it to show with a two digit month and day and then be converted to YYYYMMDD format.
I have a text field (0000000.00000) and I need to convert it to a numeric field. I have tried Int(Field Name) and set the properties to Fixed with a decimal value of 5. When it converts, it places all 0's after the decimal point.
I have a text field that contains a number and I need to multiply it by 100 but it is returning an error. Other than re-importing the data, how can I get around this error?
Skip,
in addition, i have set these fields to have a default value now and when I run the first query, it should populate the default values. For some reason, some of the fields are not being populated with the default values that I have defined. Do you have any suggestions?
Thanks -
Chris
Skip,
I got a validation rule violation and I think it is because this data is imported into a database as a text field. Do you have any suggestions on how I can get around this other than having to have someone re-import the data and change the field types?
Thanks
it doesn't have a meaning. It is not in the actual formula. However, in the process of working on this issue, I have uncovered another one. The Went Negative field was imported as a text field instead of a Date / Time field. So, I am in need of a way to convert this field to a Date / Time...
I am trying to find the difference between Todays date and another field called Went Negative Date. I have the following code in place but I am receiving an error. Please help me locate the error in my code.
=DateDiff("d",[WentNegative],Now())
Table A has a value of 2084510010 and table B has a field (begin number) with a value of 2084510000 and a field (end number) with a value of 2084510100. I have multiple values in Table A along with multiple ranges in table b. I need to see which values in table a do not fall into one of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.