Date format on calculated fields

Hi all

I have a problem with calculated date fields on my extracted CSV from
aggregate . I have one field where i am entering the date and several
fields who derive the date from this entered one .On the attached sheet *SDADAT
*is the one entered and the other fields AAADAT, PVADAT , EEADAT derive
their value from this date .If you notice on the csv file when you extract
the data the date formats on the calculated ones are different from an
entered date .

I have an application that is giving me problems with these calculated ones
i need them to be in the original form i.e. 00:00:00 as it is for the
SDADAT one .How can i do this if possible

Thanks

Mukanya

extract.csv (644 Bytes)