Cant sort dates in table

[Peltz]

Hi there

Ive written a code that timestamp a certain cell in a table:

ws2.ListObjects("Table1").DataBodyRange(i, 1).Value = Format(Now(), "dd.mm.yyyy")

However, when trying to filter the dates in the table they are not recognized as dates. The whole collumn in the sheet is formatted as dates beforehand as well. If i try to change formatting the cell to, say (dd.mm.yy), nothing happens (allthough the other dates in the table change).

Any idea on whats going on here?

 

[Joe4]

That is because the Format function actually returns a Text value, not a Date value (it converts it from Date to Text).
What you should do is to write the value as a Date like this:

ws2.ListObjects("Table1").DataBodyRange(i, 1).Value = Now()"dd.mm.yyyy")

And simply format the column as "dd.mm.yyyy"

 

[Peltz]

Ahhh, there you go.

I changed the code to

[/COLOR][COLOR=#333333]ws2.ListObjects("Table1").DataBodyRange(i, 1).Value = Now()[/COLOR][COLOR=#333333]

All is as it should. Thank you!

 

[Joe4]

You are welcome!