in
All Tags » date » convert (RSS)

Browse by Tags

  • Enter dates without separators - VBA How to implement

    The original question was: Is it possible to hand enter dates WITHOUT having ot use the separator? I've got an application where people need to hand enter lots of dates and this would make things a whole lot easier. They are using Excel 2003. For example I'd like them to be able to enter '12312006'...
    Posted to Excel (Forum) by microsoft on 05-17-2010

  • Convert string from DataGridView Column to Date

    I have a datagridview with a Date column and a Time column. As it is, the data coming from the database is not formated so the date reads something like 20050610 (YYYYMMDD) I need it to display like (MM/DD/YYYY) The same problem with the time as well. In the db it is 0834 (HHMM) but i need it displayed...
    Posted to Visual Basic.NET (Forum) by microsoft on 05-11-2010

  • RPG Free Format: Convert Date

    In Free Format any ideas on how to Convert a Date text string to CCYYMMDD Decimal Eg 'March 2006' -> 20060301 Lenght of date varies depending on Month Value Eg 'August 2007' -> 20070801 Thanks in advance.
    Posted to System Programming (Forum) by microsoft on 04-30-2010

  • I need to convert a julian date(YYYYDDD) to MMDDYY using WRKQRY

    I have a file that has records that only contain dates in julian format. (i.e. 2006082). Can you, using Query, create a result field for the julian date and have it contain the MMDDYY equivalent of the julian date? 2006082 would be converted to 032306 OS/400 release V4R3M0 Thanks, Phil
    Posted to System Programming (Forum) by microsoft on 04-30-2010

  • Unix Korn Shell - Converting Strings to Dates

    I am pulling the Day, Month , Year from various files using 'ls -l' to allow me to compare files in one directory against another. The month is coming out as 'Oct'. The problem is I need to convert my final string e.g. '10/May/2005' to a date format to allow me to filter which...
    Posted to Miscellaneous (Forum) by microsoft on 04-29-2010

  • How can I retrieve the system date mmddyyyy and convert it to yyyymmdd.

    I have one last item in my school project for an interactive display system for working with customers files and ordering files. The only thing I can't figure out is how to convert the system date mmddyyyy to yyyymmdd to use it for the order date so It can be displayed on the screen in my order date...
    Posted to System Programming (Forum) by microsoft on 04-28-2010

  • Convert ASCII text value to date/time type in MS Access

    Hi, I'm using a vba procedure to load data from a text file into an access 2007 database. One of the fields in the text file is a representation of a date as 20070829 (29th august 2007). I need to know how, within my VBA code, I can convert this to a date type in order to insert into an access field...
    Posted to Access (Forum) by microsoft on 03-07-2010

  • Convert Text field type to Date/Time

    In a text file I have a field that stores a date & time. The data is extracted from a database which stores my date/time as a text field. So it is a text type in my text file. A field value looks like this 4252006 9:44:00 AM I need it to be in a date/time format in Access. I tried playing with the...
    Posted to Access (Forum) by microsoft on 01-21-2010

  • Convert date from mm/dd/yyyy to yyyymmdd

    Is there an easy way to convert this date field from mm/dd/yyyy to yyyymmdd I need to convert the date, then export to csv, then import into a new system (custom database app). Thanks!
    Posted to Excel (Forum) by microsoft on 01-18-2010

  • Converting text to date

    I have a table with dates that are stored as text: 021204 981112 000317 I want to convert the text to dates like this: 12/04/2002 11/12/1998 03/17/2000 I'm sure this should be quick and easy...I just can't seem to do it. Thanks!
    Posted to Visual Interdev (Forum) by microsoft on 01-14-2010
Page 1 of 6 (54 items) 1 2 3 4 5 Next > ... Last ยป