Translate Month, Days, Hours, Minutes into real dates

I have an application that is giving me a 1 month, 4 days, 18 hours, 27 minutes, 7 seconds from when I run a report but I am unable to turn this into an actual date. The hours from date run are the most difficult as all the others I'm able to parse out the days with regex.

Has anyone else had this as an issue and have a solution?

Regex

Date Time

Accepted answers

martinding

Hi @brandonavants,

Please see attached:

Date example.yxmd

All comments

SPetrie

Can you give some more examples of the values you are getting? Having a wider range of examples to look at will help.

martinding

Hi @brandonavants

This reminds me of a weekly challenge:

Challenge #10: Date Time Calculations https://community.alteryx.com/t5/Weekly-Challenge/Challenge-10-Date-Time-Calculations/td-p/36737

If this weekly challenge doesn't help, could you give a bit more information on the issue you are having?

brandonavants

Martinding,

Well, that is the backwards of what I need. I am literally given 1 month, 4 days, 18 hours, 27 minutes, 7 seconds and I need to turn that into 3/05/2023 ( think that is right)

martinding

Hi @brandonavants,

Please see attached:

Date example.yxmd

brandonavants

This is it! I need to subtract though, not add.

martinding

I see!

In that case, it is easier to use a Multi-Field formula to turn all the date/time fields into negative before applying the formula tool.

* You could also just give each field a "-" sign in the formula tool itself (within the DateTimeAdd, but it is more manual and prone to errors).

Date example.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703