 |
10-21-2002, 04:24 AM
|
|
Contributor
|
|
Join Date: Apr 2002
Location: Israel
Posts: 390
|
|
date format
|
Hi,
I have some msflexgrid with some date field in,
do you know how i can set the date format to dd-mmm-yy ?
currently it always appears as mm/dd/yy
|
|
10-21-2002, 04:52 AM
|
|
Steppe Walker
Retired Moderator
* Expert *
|
|
Join Date: Jul 2002
Location: Ukraine/Russia/Belgium
Posts: 7,227
|
|
|
Hi,
With MSFlexGrid1
Dim i As Integer
For i=1 To .Rows-1
.TextMatrix(i,3)= Format( .TextMatrix(i,3), "dd-mmm-yy")
Next i
End With
Hope this helps,
Shurik12.
|
__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell
"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'
|
10-21-2002, 05:08 AM
|
|
Contributor
|
|
Join Date: Apr 2002
Location: Israel
Posts: 390
|
|
|
Thanks but can i do the same in the sql phase ?
|
|
10-21-2002, 05:20 AM
|
|
Steppe Walker
Retired Moderator
* Expert *
|
|
Join Date: Jul 2002
Location: Ukraine/Russia/Belgium
Posts: 7,227
|
|
|
As far as I know you have to explicitely do it for the grid.
(You could try it in your sql: ....Format(Field1,"dd-mmm-yy")... and don't do it in for the grid, the result would be the different).
Regards,
Shurik12.
|
__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell
"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'
|
10-22-2002, 07:20 AM
|
|
Contributor
|
|
Join Date: Apr 2002
Location: Israel
Posts: 390
|
|
|
Can someone help here please ?
|
|
10-22-2002, 07:24 AM
|
 |
Senior Contributor
|
|
Join Date: Jun 2002
Location: Mayo, Eire
Posts: 967
|
|
|
SELECT Format(DateField,"dd-mmm-yy") AS GridDate
FROM GridTable
ORDER BY DateField Desc
try merging that with your SQL statement, it should work.
|
__________________
Davie
If at first you don't succeed; don't bother trying again, just go to the pub!
Why is a person that handles your money called a 'Broker'?
If quizzes are quizzical, what are tests? | Tiocfaidh ar La
|
10-22-2002, 08:15 AM
|
|
Contributor
|
|
Join Date: Apr 2002
Location: Israel
Posts: 390
|
|
|
It's working thanks a lot
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
|
