Search results for query: *

I have a set of values in table NPANXX and need to delete records in Table 2 where Field A in NPANXX equals Field B in Table 2.

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.

How can I convert text to a date so that I can add 30 days to it?

How can I add 30 days to an existing date field

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.

The values look like 20051109 and 20051106. I have tried datediff but it did not work

I have 2 fields that contain dates that are text fields. How can I calculate the difference between the two dates?

Because I don't have time to try and reconvert at the moment. Do you have any suggestions on how I can get around this temporarily.

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

Will this compensate if there are null values as well?

No, not if I can get the format to look correct

I have two fields (Phone #, add on). I need to create a single record for each phone number and unique add on.

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

I have multiple fields where the date is imported as M/D/YYYY. I need to find a way to convert it to YYYYMMDD.

Worked like a champ. Thanks so much.

I tried that and I am still getting a #Error. Went Negative is in the DB as a text field (ie. "20051231"). Any other suggestions?

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...