OCONV( ICONV( DateFld :'-01', 'D2-YMD'),'D4,YMD')
will do it assuming your data is YY-MM and you want the result to be the first day in the month.
Note that you can't use it in a dict conversion field but in a program (as written) or in an I-descriptor as follows:.
e.g.
I ICONV( DateFld:'-01', 'D2-YMD') Date Y4 D2,YMD S
-- mats
[EMAIL PROTECTED] wrote:
I have in Universe a field for the Period as "99-01","00-02","02-01","03-05","04-04". Using ODBC/Access, I want to convert the period to "yyyy,mm,dd" format. What would be the syntax for such conversion?
Thanks Krish ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/