Hi,
My data is in below format. I wanted to subtract two dates like this 3/22/2017 14:20 -3/22/2017 14:21 for each number. Date format is in below.can any one help on this? Please let me know if you have any questions.
Number | UpdatedDate |
AAA | 3/22/2017 14:20 |
AAA | |
AAA | 3/22/2017 14:21 |
BBB | 9/29/2017 16:02 |
BBB | |
BBB | |
BBB | 9/29/2017 16:29 |
CCC | 2/22/2018 15:48 |
CCC | |
CCC | 2/22/2018 16:19 |
Solved! Go to Solution.
I think this is the problem. If you look at the original sample data it does not have seconds. Some appear to have.
Ben
Hi BenMoss,
Your formula is working but date difference is not calculating few dates. Date difference is zero is showing for below dates.I have pasted few of the date samples where as date difference is zero. Can you help on this?
Forex:
Max_DateTime_out | Min_DateTime_Out |
02/09/2018 8:03:41 | 02/08/2018 15:32:42 |
02/05/2018 14:13:29 | 03/01/2018 12:03:50 |
02/06/2018 10:20:01 | 02/08/2018 11:18:46 |
Pinky can you please ensure you post the data as it is at the start of the workflow (i.e. a single column), as I believe this is confusing things.
I tried the following based on the first line you posted here, with the structure...
Number | UploadDate |
AAA | 02/08/2018 15:32:42 |
AAA | |
AAA | 02/09/2018 8:03:41 |
and again, it seems to work fine. The only problem is it is trimming the seconds as this was not specified in your original sample data, but this still doesn't lead the result to being zero.
Ben
see attached.
It is working now. You are right the format is different for few dates.
Thank you everyone. All the above formulas helped me.