Detect date and set a range

Help
, ,
1

good afternoon

I would like to detect today’s date, I mean the current one and then establish a range of the current date and two days before, an example would be today for example is 02/16/2020 and my range would be 14,15,16. that’s the first idea

the second would be to detect the date of the excel, and to know if they are within the range, and if it is outside the range to establish up to a subtraction of two days example: let’s say I get from the excel a date of 02/18/2020 would be within my range, since my limit is two days late, that is 02/16/2020, but it would be out of my limit if it were 02/19/2020

I hope you can help me

2

Hi @borismh

Now.addDays(-2).ToString(“MM/dd/yyyy”)

Thanks
ashwinS

1 Like
3

@AshwinS2

good morning now I want to extract only the day of the current date I should do

4

Hi @borismh

Try this

Now.ToString(“DD”)

Thanks
ashwin S

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.