1
  • MS Access Date Conversion in a Query

    I have a start date field in a table, I need to calculate a completion date that is 6 months later but it must also be a Friday. I know how to calculate the 6 months part but I don't know how to advance the date to a Friday. For instance if the start date is 4/15/13 then the completion date must be...

    mac3225 pointsBadges:
  • Converting AS/400 calender date to julian date

    How to convert calander date to julian date by using query commands?

    Aabbmadush5 pointsBadges:
  • Syntax Error when converting date

    When openning the accounting day the error messges on any computer states:Syntax Error when converting date, as they log in.

    Debbieo5 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:
  • Separating dates into year, month and day componrents

    I have an excel file of some 80,000+ records, one of whose columns - C- is in date - YYYY/MM/DD form. I want to split off the date into separate columns of years and months. I've managed to split off the years by using the expression LEFT (C2,4) where C is the label of the column containing the...

    Rogerc5 pointsBadges:
  • (AS/400 – RPG(ILE)) Date-Conversion

    Date-Conversion --------------------- I have a date in 7-digit format in '1YYMMDD' format. e.g 1071231 for representing 31st of December 2007.(where '107' represents 2007; 12 represents December & 31 represents 31st Day of the month). Now i need to convert this into '31/12/2007' (European format)....

    svankipu620 pointsBadges:
  • To convert date from one format to another in COBOL

    I have date in form 01/01/09 (dd/mm/yy) and i want to convert it to 01-Jan-09 using array in cobol.Please Help me in this regard.

    Rupesh0910 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