fj = "Feb 18, 2020 20:00"
fullDataTime = Format(fj,"dd/mm/yyyy hh:nn")
hi again,
i was trying to incorporate it in my code, but it seems it´s not posible to pass that string as a variable
fj = "Feb 18, 2020 20:00"
fullDataTime = Format(fj,"dd/mm/yyyy hh:nn")
? fulldatatime
18/02/2020 20:00
Gasman,
This is very strange :
I have the variable fj defined as a string, and from the inmediate window I get :
Code:?fj Feb 18, 2020 20:00 ?Format(fj,"dd/mm/yyyy hh:nn") Feb 18, 2020 20:00
try datevar = cdate(date_string)
fj = "Fev 18, 2020 20:00"
Didn't you notice that I used date delimiters ## in both my replies?
?cdate(#Feb 18, 2020 20:00#)
18/02/2020 20:00:00
?#Feb 18, 2020 20:00#
18/02/2020 20:00:00
Hi Paul
The question was really intended for the OP....