Filter DataTable by Date doesn't work

Help
1

Can someone have a look at my workflow and tell me why it doesn’t work. or even help me fix it?

ExtratByDate_SNB.xaml (14.3 KB)

2

Buddy @Blerton_Ismaili

Kindly send with project.json file as well as there is some issue in my studio opening your xaml and may i know what was the error you were facing with that…
Cheers

3

Report.zip (1.7 MB)

Here it is buddy can you help me? @Palaniyappan

1 Like
4

Buddy may i know what was the error you were facing… @Blerton_Ismaili

5

@Palaniyappan
image

6

Buddy at which workflow buddy @Blerton_Ismaili
because we have lot of assign activity buddy thats why
dont mistake

7

@Palaniyappan it’s this one image

8

I’ve modified it as little as possible so you can still follow your process flow.
Some data formatting that you were doing was unnecessary

Hope it helps you

ExtractData.xaml (9.8 KB)

9

@paul.placintar sorry. it’s the file called “ExtratByDate_SNB” in the folder “ReportPage”… sorry

10

My bad, uploaded the wrong file
ExtratByDate_SNB.xaml (14.1 KB)

11

@paul.placintar hey thank you. but the filter is still not working… this is my main problem. it just puts all the entries into the excel file and not just the ones of the last 7 days

12

ExtratByDate_SNB.xaml (16.6 KB)

I’ve tested it this time and it’s working.
When comparing dates it’s better to use vb.net and c# built in functions to reduce the error
So below I’ve added 2 assign just for the code lisibity (they are used to store the current system date and each date from the table)
The DateTime.Compare(d1,d2) compares the 2 dates and gives an integer as result. (Use microsoft documentation for more details)
You have your Time.add(-8) in a comment and a testing assign with a random date to validate if it’s filtering some results

1 Like
13

@paul.placintar

for me it’s not working.

this is my output:

image
image1064×296 13.5 KB

it just puts out everything…

14

@paul.placintar it works now… i had to clear the excel file

1 Like