https://community.blueprism.com/t5/Digital-Exchange/Blue-Prism-How-to-calculate-text-date-times/m-p/63508#M2551 <P>is it possible to calculate text dates? Or to remove just the rest of my text?</P> <P>I need to calculate days of leave. I have two data items and I must substract one from another. For example 11/3/2017 12:00:00 AM - 3/31/2017 12:00:00 AM. How can I do this? So far I've tried Replace function. I wanted to use Mid, Trim and Left but the characters in my date items are going to change. so sometimes I will have 9 characters (11/3/2017) and sometimes 8 (1/3/2017).</P> <P>Which function could I use ? this format is month/day/year and mine is day/month/year</P> --------------------------------------------------<BR /> <B>Disclaimer:</B> This content was auto-posted from Stackoverflow. The original Stackoverflow question is here <A href="https://stackoverflow.com/questions/57111575/blue-prism-how-to-calculate-text-date-times">Stackoverflow Post</A>, posted by <A href="https://stackoverflow.com/users/10124240/daenerys">Daenerys</A>. Mon, 05 Aug 2019 14:30:00 GMT Digital_WorkerB 2019-08-05T14:30:00Z https://community.blueprism.com/t5/Digital-Exchange/Blue-Prism-How-to-calculate-text-date-times/m-p/63508#M2551 <P>is it possible to calculate text dates? Or to remove just the rest of my text?</P> <P>I need to calculate days of leave. I have two data items and I must substract one from another. For example 11/3/2017 12:00:00 AM - 3/31/2017 12:00:00 AM. How can I do this? So far I've tried Replace function. I wanted to use Mid, Trim and Left but the characters in my date items are going to change. so sometimes I will have 9 characters (11/3/2017) and sometimes 8 (1/3/2017).</P> <P>Which function could I use ? this format is month/day/year and mine is day/month/year</P> --------------------------------------------------<BR /> <B>Disclaimer:</B> This content was auto-posted from Stackoverflow. The original Stackoverflow question is here <A href="https://stackoverflow.com/questions/57111575/blue-prism-how-to-calculate-text-date-times">Stackoverflow Post</A>, posted by <A href="https://stackoverflow.com/users/10124240/daenerys">Daenerys</A>. Mon, 05 Aug 2019 14:30:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Blue-Prism-How-to-calculate-text-date-times/m-p/63508#M2551 Digital_WorkerB 2019-08-05T14:30:00Z https://community.blueprism.com/t5/Digital-Exchange/Blue-Prism-How-to-calculate-text-date-times/m-p/63509#M2552 There are several ways to accomplish what you are trying to do. But I think the easiest approach will be as follows...<BR /><BR />Assumptions: [Date String 1] and&nbsp;[Date String 2] are Text data items, containing the values "<SPAN>11/3/2017 12:00:00 AM" and "3/31/2017 12:00:00 AM" respectively</SPAN>.&nbsp;[Date 1] and&nbsp;[Date 1] are Date data items.<BR /><BR /> <UL> <LI>Use a Multi Calc stage to convert the Text data items containing the date strings to data items of Date type <UL> <LI>Example:&nbsp; <UL> <LI>Assign the result of <EM>ToDate(Trim([Date String 1]))</EM> to [Date 1]</LI> <LI>Assign the result of <EM>ToDate(Trim([Date String 2]))</EM> to [Date 2]</LI> </UL> </LI> </UL> </LI> </UL> <UL> <LI>Use a Calc stage to execute the DateDiff function on the Date type data items populated from the previous step <UL> <LI>Example: <UL> <LI>DateDiff(9, [Date 2], [Date 1]) will yield 217 days</LI> </UL> </LI> </UL> </LI> </UL><BR /><BR />------------------------------<BR />Darrell Coleman<BR />Digital Exchange Technical Reviewer<BR />Blue Prism<BR />America/New_York<BR />------------------------------<BR /> Mon, 12 Aug 2019 20:59:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Blue-Prism-How-to-calculate-text-date-times/m-p/63509#M2552 DarrellColeman 2019-08-12T20:59:00Z