| 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.
>
|
|