yesterdays date

I have a CSV file with date filed on it, I would like to filter yesterday data dynamically each day. This workflow runs every day. I have tied to filter it out and this filter gets null after I changed it to date field after the CSV file.

Can you explain to me please when I am doing wrong here ?

Data Investigation

Accepted answers

afv2688

Hello @Borisham

I have set up this little workflow where I first convert to date and after do the filtering.

If you need anything else let me know.

Regards

set_date.yxmd

All comments

afv2688

Hello @Borisham ,

Have you tried to filter using the datetimenow function?

[DateColumn] = DateTimeAdd(DateTimeNow(),-1,'days')

This funtion as it is set up right now will take only rows which have yesterdays data.

Regards

Borisham

Thanks @afv2688

How should I use in this function ? can you explain this please ?

My workflow looks like

1. CSV file (event-date)

2. Select, all the fields type as V_String and I have changed the event-date to Date field in order to help me to filter this field.

3. at this point - all the data in this field look like NULL and I don't get why

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335