Date Calculation

Finding Seasonality for a large number of items in Excel.

I am trying to establish any seasonality with what is, unfortunately, a large number of items and a relatively small time sample.  I have 32,000 different items which have typically sold at a steady pace over the past three years.  I have the sales of each item by month for the previous three...

converting date + time into timestamp

Hi I'm trying to convert date+time into timestamp n get thousands of error... my code is as below c     FMTIMCHAR     ifeq      '*ALL' Eval      FMTIMCHAR = '0000' C                   Eval      T1 = %subst(fmTIMCHAR:1:2) + ':' + ...

SQL Query Issues with date math

Table with partial sample data would appear as follows: EQUIPNO  ASSEMBLY  START_TIME  END_TIME 150          0              24-MAY-09   25-MAY-09 150          0              25-MAY-09   25-MAY-09 150          0             ...

Date Handling

How do you add a numeric field to a system date and have it calculate a new date with the variable numeric number added to the date - ex. 2009-02-07>>> 2009-02-10. (in this example, the numeric value would have a "3" loaded into it)

SQL Script

I am trying to write a sql script that will ask for a date range each time it's run. How do I do this?

Date calculation question

I have a date manipulation question on the AS/400. I need to be able to take whatever date the system date is and calculate the next Friday date and output that to the LDA in the format MMDDYY. It needs to have the leading zero for the single digit months AND it is just a 2-digit year. I swear I...