Dynamic: Getting the day Before

Hello.

I´m trying to find a way to get information from the last day in a database.

Lest say that the database has a field (date_1) with a format like this ‘220708’ (July 8, 2022) so, I would like to use a formula tool (or something similar) that allows me to get information in this way without the user intervention.

Thank You

Workflow

Developer

Input

Reporting

Output

Date Time

Help

Dynamic Processing

In Database

In-Database

Accepted answers

AdamSt

Hi @neromerob

This workflow will get either the previous day if the current date is not Monday or the last 3 days if it is Monday.

Getting the day Before Answer.yxmd

All comments

binu_acs

@neromerob one way of doing this

GEtInfo_11_07.yxmd

AdamSt

Hi @neromerob

This workflow will get either the previous day if the current date is not Monday or the last 3 days if it is Monday.

Getting the day Before Answer.yxmd

neromerob

Hello. @binu_acs

First of all thank you for the help.

Maybe I didn´t explain myself better and for that I do apologize.

what i need is a formula tool, or something like that can provide the information from the previous day considering that if i run the workflow on monday, it will return the data from friday, saturday and sunday. For example, If i run the workflow today (12-07-2022) i should get the information for yesterday (11-07-2022) and if I run the workflow next monday (18-07-2022 ) I should get the info from Friday and the weekend (15,16,17 of July 2022) .

Thank you

Luke_C

Hi @neromerob

I think @AdamSt 's solution has you covered.

neromerob

Hello @AdamSt

Thanks for the help, I try to used the workflow that you gave me but maybe i´m missing something.

here I add a dummy table that looks like this.

if i run the workflow today (July 12) i should be getting 112043 rows.

Thank you, and my apologize for not providing this data before

test_table_date.xlsx

binu_acs

@neromerob Sorry I interpreted your question in different way, I updated the filter conditon like below and ran your latest file uploaded. Can you check it is working for you or not?

DateFilter_12_07.yxmd

neromerob

thank you so much @binu_acs , @AdamSt and @Luke_C those codes where able to solve the problem, still i have to whait to see what would happen if i run the workflow next monday but i think we are ok.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703