Hi , i extract from a pdf file a string which is in “dd/mm/yy” format and i would like to convert it into “dd/mm/yyyy”
i tried convert.ToDateTime(“13/03/19”).ToString(“MM/dd/yyyy”)
but i got the error : Conversion from string "24/10/18" to type ‘Date’ is not valid.
Assign to a date variable: Convert.ToDateTime(dt.Rows(0)(“YourDate”).ToString).Date
DateTime.ParseExact(convertedDate.ToString(“dd/mm/yy”), “dd/mm/yy”, Nothing).ToString(“MM/dd/yyyy”)
my workflow is just composed with 2 assign and 1 write line
Daterecep <= “The date String”
out_DateRecep <= Datetime.parseexact(Daterecep,“dd/MM/yy”,system.globalization.cultureinfo.invariantculture).ToString(“dd/MM/yyyy”)
and i write out_datarecep.
the final objectif is to write that date on excel but with the date format (by now it is written with standard format)
To achieve this first take a sample excel sheet and have a column called Date and select the complete column and right click and format cells and go to category date and select the format dd-MM-yyyy for ex(14-03-2012)
Now refer the below workflow and write the output variable to the column under date
i can’t have the right to modificate the excel sheet,
in my sheet i have 13/03/2019 00:00:00 visible on the cell but on the table i have #########
how can i seperate dd/MM/yyyy from hh:mm:ss ?