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)....

    svankipu625 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.

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

Following