Subject Re: DMY()
From Andy Taylor <andy.taylor.1959@outlook.com>
Date Sun, 30 Aug 2020 16:46:24 -0400
Newsgroups dbase.getting-started

gilbert,

Your program should work as written to store the date within the table.
You cannot specify a particular format for the date entry in a date field.
The dBASE date type takes up only 8 bytes of storage in the table.

You can display the date field in a number of different ways by converting it to a string format. Ken has pointed you to some code in the DUFLP that will help but it is not like excel where you just specify a custom format.

You need to build it with code, so "Aug" would be ? left(cMonth(Fecha,3)

Most of us have library code that does this that returns the entire date string and I can share mine if you want.  Also, you don't say where you want to display the text.

Andy

> How can I write DMY() in this program to make the field Fecha as
> Aug 29 2020  and not as  08/29/2020  . The examples in Ken Mayer book don't give  an easy example.
> Thansk very much If I can get an anwer to this problem.
>