How can I change '20020425' date format into 2002/04/25.This message has been edited. Last edited by: Kerry,
Hi welcome to the Forum. Use the Search at the top for 'Convert Date'. You should find many examples.
Or EDIT using '9999/99/99' as the mask.
DevStu WF 7.6.11
HTML, PDF, EXL2K
the answer depends on the original format of the date
is it number in the database
is it a string in the database
is it a date in the database
And to add to Franks list.
Is it a Dialog Manager variable. ( See jimster06's post)
Always impressed when I see questions about Dates Format. A matter that was fixed by Focus well before 31/12/1999 (Except the Windowing of centuries with YRTHRESH or about that came for the big Millenium boom).
As to the Type of DM variables, it should not be confused with Focus Formats. DM variables are always characters, perhaps numeric characters, that you can calculate with, but characters nonetheless.
Sorry to have interrupted ...
Focusely and Cordially
Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
|Powered by Social Strata|