| Author |
Converting Date Field from dBase VI to 5.5ee
|
|
| Lenda40 2004-07-06, 3:55 am |
| Can anyone suggest a method to convert a dBase VI date field (yy/yy) to a
Clarion date field?
| |
| Jack van Munster 2004-07-06, 8:55 am |
| Hey there
Look at deformat( )
It realy works
"Lenda40" <lschwarz@nospam.arbbs.net> schreef in bericht
news:3140081ff28b8f3199f7a627a232fe8c@lo
calhost.talkaboutprogramming.com...
> Can anyone suggest a method to convert a dBase VI date field (yy/yy) to a
> Clarion date field?
>
| |
| Lenda40 2004-07-07, 3:55 am |
| Thanks for your answer. I agree that I can use DEFORMAT() to interpret the
field. However, I need to have the same type field (yy/yy) in the new
program as a date--it does not sort properly unless it is a date field.
DATE does not even have a picture for year only. Presently I am creating
a seperate field for use to sort by using SUB and adding either a 19 or a
20 to the front but I am sure there must be a better way.
| |
| C.Joseph Drayton 2004-07-07, 3:55 am |
| Hi Lenda40
Couldn't you use the year() function to return the year of a specified date?
Ciao . . . C.Joseph
That which a man buys too cheaply . . .
He esteems too lightly
Lenda40 wrote:
> Thanks for your answer. I agree that I can use DEFORMAT() to interpret the
> field. However, I need to have the same type field (yy/yy) in the new
> program as a date--it does not sort properly unless it is a date field.
> DATE does not even have a picture for year only. Presently I am creating
> a seperate field for use to sort by using SUB and adding either a 19 or a
> 20 to the front but I am sure there must be a better way.
>
| |
| Lenda40 2004-07-07, 3:56 pm |
| Thank you for your reply. I could probably extract the year from the field
(yy/yy) but I need to have the destination field in the same format (which
Clarion does not have as a DATE). I guess what I need is a way to modify
the DATE pictures but I haven't even a clue how dBase VI makes this work.
|
|
|
|