how do i convert days from december 31 1967 to a conventional date

[edward gould]

how do i convert from pick os internal date to microsoft access

[gershwyn]

There are a couple ways to do it, depending on what you want to do precisely. Assuming you have a string with the value "December 31 1967", you could convert it to the date data type with the DateValue function

DateValue("December 31 1967")

or use the Format function to change it into a string with a different format.

Format("December 31 1967", "mm/dd/yyyy")
Format("December 31 1967", "ddd, m/d")
Format("December 31 1967", "m-d-yy")

Output:

12/31/1967
Sun, 12/31
12-31-67

I would suggest reading the help file entries for those two functions to learn more about how they work.