1
  • UK date formatting in MS Excel 2007

    As I enter a date in UK format in Excel 2007 it is taken as text. The date I entered is 23/12/2009. How to get it as a date.

    kotayyam5 pointsBadges:
  • Date

    I want to get records from July 1, 2012 to June 30, 2013. What should I put in the criteria?

    JaneDitmars20135 pointsBadges:
  • UTC Date/Time formatting using Javascript

    Hello Everyone, I'm having trouble figuring out how to format a date and time for display. I'm using the Google Stock Quote API to generate XML and processing that XML for display. Here's the link to the XML: http://www.google.com/ig/api?stock=GOOG When processing that XML, you get a trade date and...

    Dcantwell465 pointsBadges:
  • Giving in Date Range in Crystal Reports 8.5

    I am trying in Crystal 8.5 to get records for those who did not donate in a given date range, but did give in a different date range (i.e. did not donate 5/1/1985 thru 4/30/2009, but did donate 5/1/2009-4/30/2010). Those who meet the criteria are then marked as "new donor". I am getting too many...

    Mystic15 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:
  • 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:
  • sql update command to update a date-of-birth

    I need to change the date-of-birth MONTH to May and DAYS to 15 without changing the YEAR

    Mji50 pointsBadges:
  • Convert date format

    How do I convert the given number to date format e.g. 2009062 should result in 03-Mar-2009.

    SanikaGurav10 pointsBadges:
  • Converting Julian date to Gregorian in WrkQry

    I work on an Iseries AS/400 and when I do a wrkqry for reports I need to convert the date ccyyyddd(julian) to mmddyyy(gregorian)

    Lady5515 pointsBadges:
  • iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd

    Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works) SELECT...

    MarcGreen20 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