|
-
Jun 14th, 2007, 04:05 AM
#1
Thread Starter
Hyperactive Member
Flexgrid Data Format.
I have an Access database whereby Date's are stored in the form of dd/mm/yy.
Whe retreived into Flexgrid, they appear in the form of mm/dd/yyy. How can get them shown on datgrid in the form of dd/mm/yy.
Thanks
-
Jun 14th, 2007, 08:00 AM
#2
Re: Flexgrid Data Format.
Use Format function:
MsFlexGrid1.TextMatrix(row, col) = Format(your_date_filed, "mm/dd/yy")
-
Jun 14th, 2007, 09:39 AM
#3
Re: Flexgrid Data Format.
@tendemo:
For your information, in most databases, dates are stored as long integers or fixed numbers. What you're seeing (dd/mm/yy) is the display, not the storage. Regardless of how you tell the database program to display the dates, the internal storage (and the data your program retrieves) remains the same.
The most difficult part of developing a program is understanding the problem.
The second most difficult part is deciding how you're going to solve the problem.
Actually writing the program (translating your solution into some computer language) is the easiest part.
Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.
Please Help Us To Save Ana
-
Jun 14th, 2007, 11:43 AM
#4
Thread Starter
Hyperactive Member
Re: Flexgrid Data Format.
G Thanks for the format and the information will work on all right away. A la prochain.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
