Search results

  1. I

    Convert 20020322 number into Date Format

    Hi JANR, The answer below posted on 02-02-2012 03:09 PM is great and works fine. Is it possible now to work out the number of Business Days between Value_Date and Entry_Date and have the answer populate another column? Apologies for the cross-posting I am quite new to these forums...
  2. I

    Convert 20020322 number into Date Format

    Hi JR, Thanks for this, I have basic knowledge of Access. How can I use the function you have given me below to update both Entry_Date and Value_Date columns without creating new columns. So 20020322 would show as 22/03/2002 in date format for all fields in the Entry_Date column for...
  3. I

    Convert 20020322 number into Date Format

    Hi All, I have two columns in Access, Entry_Date & Value_Date. When I import this data into Access via a text file it is recognised as a number format ie 20020322. I want to show this as date format in the easiest possible way. I want to be able to show both these columns as date format ie...
Back
Top Bottom