I have been trying to merge two excel sheets with different date formats in them but I am getting the number of days instead of the date in the short date format. One format is “08-Feb-02” while the other is “01-01-1999” and I want it in “01-01-1999” format. Can anyone please help.
Change dateformat in row of datatable
use this code to change date format (08-Feb-02 to 08-02-02)
DateTime.ParseExact(“08-Feb-02”, “dd-MMM-yy”, CultureInfo.InvariantCulture).ToString(“dd-MM-yy”)
I am selecting the columns that I need by assigning “testRow.Select.CopyToDataTable().DefaultView.ToTable(False, “ID”, “Name”,“Insurance Amount”,“Dob”)” to values
Can you give more detail to better understand. Give some sample data with your xaml file
If you could send me a sample xaml on how to do this would be of great help. Thank you
is there a way to do this? I just want to know in which activity do i use the code? should i use an assign activity? if yes then what should i assign it to?
thanks a lot arivu for taking your time to help me out.