Hi In my condition here is I need to filter out the Date less than 14Days of Effectivity date (Not included the weekends)
Condition: Days Before Effectivity date >=14Days
if Current Date >= 14 days of Effectivity Date
Else Current date < 14days of Effectivity Date
Please see sample below for reference
Thank you in advance.
I have created the code logic in the attached xaml file I hope it will help you
Sequence1.xaml (19.9 KB)
Can I have the screenshot instead?
I cant open the file because of the project version
I have attached as a solution. Can you try this one Date.zip (3.7 KB)
What do you think is the error here?
@Vincent_Nuestro Effectivity Date is not valid date string let me know what is the value are you getting from
at this point?
@Vincent_Nuestro as per your first screenshot I used that date format and now the current screenshot shows different
Can you change the code for EffectivityDate assign to like below?
EffectivityDate = CDate(row(“EffectivityDate”).ToString)
hi @aanandsanraj it works now:)
but how do I remove the 00:00:00
You are welcome @Vincent_Nuestro.
EffectivityDate is datetime datatype so as of now there is no time in the input date so it is taking default time as 00:00:00. If you want remove the time you have to convert to string like below. Note EffectivityDate datatype must be string.
Thank you so much for your Help @aanandsanraj
You are most welcome @Vincent_Nuestro
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.