1
  • Flip Dates

    Hi, I have a file with numeric field which contain date values. The file is huge in size and some of the date values are in DDMMYYYY format and rest of them are in YYYYMMDD. The program writing the date values in DMY is fixed recently but I need to flip the previous records which is in DDMMYYYY...

    NicyChn75 pointsBadges:
  • ‘convert as/400 dates ’0001-01-01′ to SQL Server 2000′

    How do I convert ISO dates of '0001-01-01' to SQL Server 2000 Datetime format?

    Jld10 pointsBadges:
  • Convert time stamp to dd/mm/yy

    How can I convert a timestamp field(declared with type 'Z' in database) to dd/mm/yy format in RPG?

    RamvishakRamesh2,410 pointsBadges:
  • AS/400 Query – Current date -1

    Is there a quick and easy way to calculate yesterdays date by using "Define result fields"

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

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

    Aabbmadush5 pointsBadges:
  • Take a date and format to MDY in RPG IV

    I have a date coming in from a file (ADDate Zoned 8 0) so it comes out 20090428 but I want to have it convert to 042809 how can I do that? thanks  

    Jaymz69765 pointsBadges:
  • AS400 query

    I want to be able to write a query that says take xdate field plus a number of days. How do I do this

    Kzjtbm5 pointsBadges:
  • AS400 Time Zone changes

    Where do i see the date and time that my time will be changed

    Yank275 pointsBadges:
  • AS/400 Date edit – I/O

    I have a date field used for input and I want to display the field as   /  /  . and allow the user to type in the numbers where the field puts the numbers where they belong and doesn't disturb the edit for slashes.  I thought there was an attribute that would do this, can anyone help me??

    LMorgan5 pointsBadges:
  • How to convert date format from one format to another in RPG/400?

    how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE

    Kaly470 pointsBadges:
  • Integrating MS Outlook With iSeries

    I have been asked to display a calendar such as what Outlook has showing dates of events that are stored in the AS400. Just to complicate things, the users would also like to reschedule appointments so we need to update the AS400! (I may be able to talk them out of this) Does anyone have any ideas...

    Pratty5 pointsBadges:
  • Last Day of Month

    Is there a routine to arrive at the exact last day of the month? *Month doesn't do it.

    Djomay5 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:
  • extracting data and converting AS400 date format

    hi, this question is very simple I should guess.. I am trying to extract data from AS400 into excel, and since date format is CYMD, I want it to show in a MM/DD/YYYY format. Please show me how.. Thank you very much! p.s. in SQL please

    MasterJediWannabe15 pointsBadges:
  • Date format in AS/400 display file

    How to alter the date format in the display file

    Kecviji5 pointsBadges:
  • Data selection criteria to pull last months information

    I run a series of queries at the beginning of each month to pull transactions from the previous month.  Currently I am setting the date range for the julian dates.  I would like to automate this series of queries and need a way to automate the data selection criteria so it will automatically pull...

    Clhalfa30 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:
  • AS/400 date format

    How do format a date field to MM/DD/YYYY?

    ZSID35 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:
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