>my forms's date format is dd-mm-yyyy (set date italian dmy)
>Now, I want to show it in report as yyyy-mm-dd (in string format )
>How can I save the date format form dd-mm-yyyy into string format (yyyy-mm-dd)
Agnes,
Edward's suggestion is one way, another way is :
PARAMETERS pddate
LOCAL lcReturn
lcReturn = ""
lcReturn = ALLTRIM(STR(YEAR(pddate))) + "-" ;
+ PADL(MONTH(pddate),2, "0") + "-" ;
+ PADL(DAY(pddate),2,"0")
ENDIF
RETURN lcReturn
not tested, just changed from my code. Mine said no dashes in format YYYYMMDD.
HTH
Beth