Calcualte date and time diffierence

[Dansav]

Ok Im kinda new here so any help would be really helpful. I need to build a workflow to identify instances where a job was opened and then closed and then if a job of the same description was opened within 7 days however I also need to calculate the time which this happened also.

I have the following fields

Date job opened 

Date job closed 

Job description 

Many thanks in advance

[fmvizcaino]

Hi @Dansav ,

Would you be able to share a sample of your dataset with an example of what you want to achieve? That way I can build or guide you into building exactly what you need.

Best,

Fernando Vizcaino

[Blake]

Hi @Dansav, 

I agree with @fmvizcaino, a sample of your data would be really helpful. What does it look like when a job doesn't close? Do you need to know if there are multiple jobs of the same JD that were opened in the prior 7 days or is just a yes/no flag ok? 

I mocked something up based on the assumption that your dates are already in yyyy-mm-dd format and that you just need to know if a job opening has occurred within 7 days of the previous posting. 

See the attached workflow and let me know if it fits what you're looking for. 

[Dansav · Accepted solution]

Sorry I should have been a bit clearer, my apologies. Thanks for everyone's interest and help so far.

So is what I'm trying to determine if this company has cancelled a priority work order to avoid not meeting a response time and then created a new job order with the same description within 3 days (sorry originally said 7 days). Please note I will need the formula to calculate time as well (obviously). The output will need to compare both instances. 

Hope this helps. 

Many thanks again, I really appreciate your help. 

[Dansav]

@fmvizcaino

I've added a comment which hopefully clarifies