1
  • conditional calculation

    want to create new field e.g. DATE2 = CURRENT DATE - EXPIRY DATE. how would I represent current date in my formula

    jharding5 pointsBadges:
  • Crystal Reports 8.0 Error

    I have created a formula called @DateCode: WhilePrintingRecords;NumberVar dblYear:= 0;NumberVar dblWeek:= 0;StringVar strYear:= "00";StringVar strWeek:= "00";StringVar strDate:= {OrderDet.User_Text1};DateVar dtDate;DateTimeVar dtDateTime;StringVar strDateCode:= "0000"; If IsDate(strDate) Then(...

    ShopTechBBaxter25 pointsBadges:
  • Determining data from a certain date range

    I have an Access 2003 database that has weekly dates and weights enter for a weight loss program. Ech program session is 8 weeks and people sign up for anywhere from 1 to many more sessions at a time. I want to find out the average weight lost in the first 8 weeks that a patient belongs, then in 16...

    HSwartzPartners65 pointsBadges:
  • Macro date a year from today

    Does any know how to create a year date from today ? for example today = 9/3/2010 I would like to get the macro variable that give 9/1/2009

    Iamjeannie30 pointsBadges:
  • Pulling previous years data based on dates entered in a from

    I am working on an access db that is used to compare call volume for current year and previous year. I would like to enter the current year's dates on a from and write a query that will pull the previous year's data based on the dates entered. When using a Date -365 expression, the query shows...

    Zip1315 pointsBadges:
  • 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...

    TomN50 pointsBadges:
  • 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...

    XENOPHON222,340 pointsBadges:
  • 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) + ':' + ...

    Nutangujar895 pointsBadges:
  • 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             ...

    Phoenix210 pointsBadges:
  • 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)

    Gallack10 pointsBadges:
  • 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?

    Ebethea5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following