Search results

  1. C

    Question Need help with iif/left statement not returning false argument.

    I'm a self taught novice so I'm really not sure what I'm doing wrong. Any suggestions are welcome. I'm trying to derive the month in digits from a date/time stamp field. Any month between 10 and 12, I need the first 2 digits but anything <=9 is only 1 digit. MONTH: IIf(Left([LOAD TO SKU LEVEL...
  2. C

    No return on false argmument in iif/left statement

    I'm a self taught novice so I'm really not sure what I'm doing wrong. Any suggestions are welcome. I'm trying to derive the month in digits from a date/time stamp field. Any month between 10 and 12, I need the first 2 digits but anything <=9 is only 1 digit. MONTH: IIf(Left([LOAD TO SKU LEVEL...
Top Bottom