Datetime format

Help
1

Hello
Well i am trying to apply filter using date column where i have used cdate to change the format of date.But while executing this cdate not returning the desired date in desired format. How resolve this issue?

2

Assign to a date variable: Convert.ToDateTime(dt.Rows(0)(“YourDate”).ToString).Date
DateTime.ParseExact(convertedDate.ToString(“MM.dd.yyyy”), “MM.dd.yyyy”, Nothing).ToString(“dd-MM-yyyy”)

3

Hi @mhk15,

Suppose you date is “13-03-2019” and you want to convert to “03-13-2019” , use the below expression, the below expression returns string , if you want date time then use 2nd expression

Datetime.ParseExact(“13-03-2019”,“dd-MM-yyyy”,system.Globalization.CultureInfo.InvariantCulture).ToString(“MM-dd-yyyy”)

Convert.todatetime(Datetime.ParseExact(“13-03-2019”,“dd-MM-yyyy”,system.Globalization.CultureInfo.InvariantCulture).ToString(“MM-dd-yyyy”))

Can you provide sample file, and what you want to filter

4

thanks for your response.But here i am applying filter activity this way as shown in figure. where it is returning value “01/01/0001 00:00:00” but should return “10/11/2018 00:00:00” . Not able to resolve this issue… is there any other way to use date in this activity??

filter
filter920×517 33.2 KB

5

Hi,

Can you print first what CDate(DateGL) has and you can also filter based on the select query

6

@mhk15 Download this zip file and see

7

Please help me with this xaml. I am sharing a zip file.not able to resolve the issuechkdate.zip (60.6 KB)

8

Refer the below workflow which selects only 2 rows which has 10/11/2018

Main.xaml (7.8 KB)

Not sure what are you doing in your workflow.

For each row and replacing every time Date1 with row(“Post Date”).tostring - Not sure why

9

yes but issue is using within the filter activity… What is the possible way to use date there in that activity??

10

Refer the below workflow with filtered datatable activity

Test (2).xaml (12.4 KB)

So in Filtered datatable activity, the value should be date time , so use the below expression and change the date accordingly

Datetime.ParseExact(“10/11/2018”,“MM/dd/yyyy”,system.Globalization.CultureInfo.InvariantCulture)