I know some form of this question has been asked to death, but the problem I'm encountering differs in that it's with the data being inputted into Excel (I know I hate it as a data source too.) Just as a bit of background the app is a medical reporting app and there are three pages for each different type of visit. One for Injury where the one of the dates chosen is the Accident date and the other is the completing Date. The other pages are for mental health visits and illness visits, and they use the same completing date selector (or a copy of) and then they use a Visit date (rather than an accident date.)
So here as you can see the date is formatted correctly and should go into excel with dd/mm/yyyy
However in the excel doc, it switches between which format it puts in the doc, for no apparent reason.
I had some trouble uploading the images so I may need to reupload if they didn't work.


Report
All responses (
Answers (