https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75417#M28022 Hi JamesWilliams, Format date function in calculation stage is useful. Try it once Tue, 22 Aug 2017 13:37:00 GMT Manohar657 2017-08-22T13:37:00Z https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75412#M28017 Hi I am having an issue with dates in object studio. I am adding a CSV file to a collection (One important field in the CSV file is a date) and when the data transfers over BP switches the day and month around. E.g. A date of 10/08/2017 becomes 08/10/2017. I don't really want to change the data type to text as I am running a decision which needs to look at dates within a range and compares it to the date in the collection. With the day and month switching this makes the date range decision unusable. Any ideas how to rectify this? Thanks Thu, 10 Aug 2017 15:00:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75412#M28017 JamesWilliams 2017-08-10T15:00:00Z https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75413#M28018 I am guessing there is a local environment setting that is impacting your dates so some kind of US/UK convesion is occuring. To ensure the date is held as you want it you could convert it from the text field using the MakeDate function - where you specify exactly how to build the date. Thu, 10 Aug 2017 15:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75413#M28018 Denis__Dennehy 2017-08-10T15:22:00Z https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75414#M28019 Thanks Denis I will give it a try Thu, 10 Aug 2017 16:29:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75414#M28019 JamesWilliams 2017-08-10T16:29:00Z https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75415#M28020 Update* I have tried bringing the data into a collection as Text but BP is still switching the date around to US format. When I run my initial report it exports the date values as dates when it writes to a CSV file. I then use BP MS Excel VBO Object to add to a collection where I have set each field value in the collection as text. Any further ideas? Thu, 10 Aug 2017 20:20:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75415#M28020 JamesWilliams 2017-08-10T20:20:00Z https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75416#M28021 HI James, Use MakeDate function or Format Date function to use it the way you want. Mon, 21 Aug 2017 13:38:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75416#M28021 PrateekMehan 2017-08-21T13:38:00Z https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75417#M28022 Hi JamesWilliams, Format date function in calculation stage is useful. Try it once Tue, 22 Aug 2017 13:37:00 GMT https://community.blueprism.com/t5/Product-Forum/Date-Switching/m-p/75417#M28022 Manohar657 2017-08-22T13:37:00Z