Data extraction issue

MD2050

Hello Everyone-

I need some assistance in understanding what i am doing wrong in the attached workflow?

Situation : i have a set of data which has employee hours by day , please see attached excel file for reference (for this illustration i just pulled yesterday's and today's data) . i am trying to schedule a job which will run every morning and will show a summary of hours worked from previous day .

I used a filter tool and in the expression box i did DateTimeAdd(DateTimeToday(),-1,"days") , for some reason this logic is not working in my case and i don't see yesterday's data at the "True" node.

Thank you very much.

sample data.xlsx

yesterdays_extract.yxmd

danrh

Try these two changes:

- Change your expression to DateTimeAdd(DateTimeToday(),-1,'days')=[Date]

- Just prior to your filter, add a Select tool and change your Date field to a DateTime type.  Right now it looks like your comparing a Date and a DateTime and the two don't always play nicely.

Hope it helps!