date time help

I am not getting the correct output can someone tell me where m i going wrong?

ideally :

-where there is no dates in both the column it should give me “PLEASE UPDATE THE DATES” in delayed column

- if closing date is not within 15days of issue date then it should give delayed

- in my output where it is within 15days or even closed the same date its still showing delayed.

another ask is if someone can help me to add first email tool prior to 5 days if that can be automated ? Email will be send only if its prior 5 days of closing otherwise no email to be sent.

and one email after 15 days only if those records who has crossed 15 days.

please help ?

IMG_7153.jpeg

Workflow

Output

Help

Accepted answers

Amit_G_Limbasia

You can Use two column like this

You can use this :

IF IsNull(DateTimeDiff([Closed],[Issued],'days'))
THEN "PLEASE UPDATE THE DATES"
ELSE(IF DateTimeDiff([Closed],[Issued],'days') <= 15
THEN "With in 15 days"
ELSE "Delayed"
ENDIF)
ENDIF

No of Days Difference

DateTimeDiff([Closed],[Issued],'days')

All comments

Amit_G_Limbasia

You can Use two column like this

DateTimeDiff([Closed],[Issued],'days')

binu_acs

@SahilArora3139

SahilArora3139

Thank you so much both of you . It works for me.
just one more doubt i have 32 entries as of now in my excel sheet but if you can see in the ss i am getting formula after 32 entry as well where the data is not there.

as i cannot delete the columns after 32 in my original excel sheet due to formulas and filter in the column

is there any way to just get the output till data /entry. (I.e just 32 records )

IMG_7167.jpeg

SahilArora3139

Also what would be the row rule if i want to send email only if we are about to breach our timeline .
forexample: close date is at 10 days and in another 5 days it will breach

so only if closing date has crossed 10days but before 15 days i want to send email as a top up reminder. Even if closing date is missing and has crossed 10 days but before 15 days.

is it possible ?

IMG_7169.jpeg

SahilArora3139

To highlight the entries what is wrong in my formula its not working ?

also after highlighting i just need those entries to be sent who are in red. And is not meeting criteria.

IMG_7171.jpeg

Amit_G_Limbasia

You can choose column rule Create Insted of row rule.

Please find attached workflow Solution1234 That might be help you!

SahilArora3139

For your workflow if i replace your filter where you have used days difference = -2

i want to write my logic :

IF DateTimeDiff([Close Date],[Issue Date],'days') > 10 AND DateTimeDiff([Close Date],[Issue Date],'days') <= 15 THEN True ELSE False ENDIF

that is want to filter true values where close date is greater than 10 but less than 15 days

or other words its like

Days delayed greater than 10 but less than 15 want to filter only .

but i am not getting correct output with my custom filter

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703