Search results

  1. J

    convert number to date

    Thank you kindly for your response, but I'm not that familiar with modules. I copied & pasted the function language as was given, but it's not working out. I'm guessing that I'm missing a line that references the name of the field that needs to be converted. You may have omitted that piece...
  2. J

    convert number to date

    I am importing data from a text file that contains dates in this format: 08012007 I am trying to convert the number to a date 08/1/2007 so that I can run date related queries. Your help is appreciated - Thank you.
  3. J

    nested IIF

    PBaldy: Thanks - The grouping with () was most helpful. Moniker: Thanks for introducing me to modules and giving me insight on how functions work. If anyone was following this - the expression worked as follows: Stat2n4: IIf(([status2]='I162' Or [status2]='I062' Or [status2]='I009' Or...
  4. J

    nested IIF

    Nested IIF Moniker: Changing to "Variant" cleared the "Datatype mismatch" error, but now the query results are either "No Status" or "#Error". The language may need some tweaking, but there seems to be somewhat of a pattern as to where the "no status" & #errors are falling, and it's looking...
  5. J

    nested IIF

    Nested IIF To Moniker: Moniker - Thanks for your in-depth reply. I couldn't figure out what keyword connected the module to the query and vise versa. Based on your response, "GetStatus" is the connection I was looking for and my attempt to force any other connection between the two was just...
  6. J

    nested IIF

    Thank you all for responding. To PBaldy & KeithG - not sure what you meant by "normalize your data", but I suspect you believe the data is not well-structured. If so, I agree - trouble is that my database is linked to a flat file that the mainframe spits out and I have no control over that...
  7. J

    nested IIF

    My first post ever... so here goes. My Goal: Columns of data contain date fields & "Status" that indicates where a case lies. I'm trying to calculate days spent in a specific area (determined by status code) and total amount of time spent there all together. Status code begining w/ "I***"...
Back
Top Bottom