Date conversion Questions

1

Converting AS/400 calender date to julian date
How to convert calander date to julian date by using query commands?

Answer Question   |  February 15, 2011  11:12 AM
AS/400 command functions, AS/400 commands, AS/400 date format, Date conversion
asked by:
5 pts.

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.

Answer Question   |  June 15, 2010  4:43 PM
Date conversion, Lms, Syntax errors
asked by:
5 pts.

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

Answer Question   |  June 16, 2009  6:50 AM
Date conversion, Date format
asked by:
10 pts.

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 [...]

Answer Question   |  June 9, 2009  3:36 AM
Date conversion, Excel 2002, Excel 2007
asked by:
5 pts.

(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). Now my question is: Is there any direct function/method/facility available in [...]

Answer Question   |  February 11, 2009  11:22 AM
AS/400 development, Date conversion, RPG/400, RPGILE
asked by:
430 pts.

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.

Answer Question   |  December 12, 2008  6:34 AM
COBOL, Cobol_Arrays, Date conversion
asked by:
10 pts.

1