Check the range of Date if falls within fifteen days with the other date

Help Studio
, ,
21

@sudster

The image shows an assign activity in a workflow, calculating the difference in days between two dates using the DateDiff function and saving it to the variable "days_from_startdate". (Captioned by AI)
The image shows an assign activity in a workflow, calculating the difference in days between two dates using the DateDiff function and saving it to the variable "days_from_startdate". (Captioned by AI)760×152 16.4 KB

This worked for me.

For start_date=“10/1/2024”
Sign_date=“9/25/2024”

I got the difference 6.

Is it fine? The logic is working I think?

22

Yes, please refer to screenshots of the variable panel in my earlier post.

This will work most of the time. It is recommended NOT to use CDate for conversion in production, if you don’t have control over the format of the input date string or can not positively predict where the process will be running. Though both CDate and ParseExact produce the same result, as a developer you want to make it clear in the code that you expect the input to be in a particular format. This will often make it easier for the next person reviewing the code.
For example
10/2/2024 can be 10 Feb 2024 or 2 Oct 2024, depending on where you are and how the computer running the process is configured.

23

@sudster

Thank You . It worked

24

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