|
Go
![]() |
New
![]() |
Search
![]() |
Notify
![]() |
Tools
![]() |
Reply
![]() |
|
|
Gold member |
I have a question to convert a date format (28/03/2004) to a string format (20040328). Is there any function or command to do this in WebFocus?
|
||
|
|
Member |
If the format of the field is "DMYY" then create a define such as this.
DEFINE FILE CAR DATE1/A8DMYY = YOURDATEFIELD ; DATE2/A8 = EDIT(DATE1,'$$$$9999') | EDIT(DATE1,'$$99') | EDIT(DATE1,'99') ; END Now you will have am Alphanumeric(text) field that is in YYYYMMDD order. |
|||
|
|
Gold member |
Thank you very much. It works fine !
|
|||
|
|
Expert |
or, using the DATECVT function which
changes the form of your smart date... temp/YYMD = DATECVT(yourdate,'DMYY','YYMD' ); temp1/A8DMYY = temp; RESULTDATE/A8 = temp1; produces... MYDATE.....temp..........temp1........RESULTDATE 13/09/2004 2004/09/13 2004/09/13 20040913 |
|||
|
| Previous Topic | Next Topic | powered by eve community |
| Please Wait. Your request is being processed... |
|

