to point is i already have a string which become a dateTime.
at the end what i want is to write the date on a excel sheet and make this cell be able to be filtred with the other date present in the file when i filter by the most recent.
at this moment the other date have been written manually and now i want it to do it with a robot. the cell format is date type but not the column. i can’t change the type.
that’s why i wanted the new date to be dateTime type
hi @grish ,
when converting a string to a datetime it comes with, say, “dd/MM/yyyy hh:mm:ss”". In order to obtain just the actual date you could simply use split methods:
thus, if date = “dd/MM/yyyy hh:mm:ss”
date.Split(" "c)(0) will solve the issue, returning a list of two elements, the first being the left side of the space " ", the second being the right side.