Explore Courses Blog Tutorials Interview Questions
0 votes
in RPA by (5.3k points)

is it possible to calculate text dates? Or to remove just the rest of my text?

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).

Which function could I use ? this format is month/day/year and mine is day/month/year

1 Answer

0 votes
by (9.5k points)

use the function ToDate({text}). 

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
0 answers
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.5k questions

29.9k answers


99.1k users

Browse Categories