Date issue

Hi community!

I made workflow which has date field dynamic as today, and the workflow scheduled to run every day at 1:30 pm. The problem which comes in is it's not capturing anything entered after 1:30pm and next day it repeats the same way. Can someone please help me to find a solution(formula) which captures the data from today afternoon till tomorrow afternoon and when it run the file will take 24-hour time period from today afternoon till tomorrow afternoon.

THANKS IN ADVANCE

Workflow

Accepted answers

Emmanuel_G

@TabsheerMohamed

I don't know if I really capture the issue. But in this workflow, you generate automatically data from today afternoon till tomorrow afternoon hour by hour.

Let me know if it is what you want.

Date issue.yxmd

All comments

ShankerV

Hi @TabsheerMohamed

If I understand your question correctly, you might have used to datetimenow()

And then used datetimediff(date1, date2, "days")

So it will give diff as 1 day.

So there might be probability of data's getting missed out.

Try to use datetimediff(date1, date2, "hours")

Then use the file is <24 hours, then all the items from last afternoon till next afternoon will come.

To make more accurate, you can do in seconds also.

Many thanks

Shanker V

ShankerV

Hi @TabsheerMohamed

Please use datetimenow() instead of datetimetoday()

That makes the big difference.

Note: Assuming the scenario based on the issue explained, hope this will work for you.

Many thanks

Shanker V

TabsheerMohamed

Yes, I will try it. The thing which I am trying to do; wanted to get whatever is entered from yesterday afternoon till today afternoon, and it should change every day.

Emmanuel_G

@TabsheerMohamed

I don't know if I really capture the issue. But in this workflow, you generate automatically data from today afternoon till tomorrow afternoon hour by hour.

Let me know if it is what you want.

Date issue.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335