Populating a text field with the date value from a datetime field
Posted on 2011-09-05
I reading in DATEA ,FIELDA, FIELDB in a dataset. Both FIELDA and FIELDB are text fields.
DATEA is a DATETIME Field.
If FIELDA is = "Y" and FIELDB is not populated I would like to move the DATEPART of DATEA to FIELDB.
How can I do this: When I just write the statement
FIELDB = datepart(DATEA) I get 18884. I would like for this value to be able to formatted into a date in the text field FIELDB.
I would like to final result in FIELDB to be 8/15/2011.