How to remove the timestamp from date field

[Sonyat810]

Hi. I am trying to update data in power bi using a csv file in access, everything pulls in except the date field due to the timestamp

[CJ_London]

a timestamp is the whole field - date and time. If you only want the date part then use the datevalue function to extract the date e.g.

?datevalue(now())
02/08/2022

[Sonyat810]

Its not showing the date at all in my csv file now

[Sonyat810]

And all of the records show today date

[Welshgasman]

And all of the records show today date

Code in post #2 was an example, you are meant to put your own datefield in the place of Now()

[Sonyat810]

I'm not good at this yet. Can you tell me what to put there

[CJ_London]

the name of your timestamp field

I am assuming you are exporting a query and not a table

[Sonyat810]

My field is called Date field. I am trying to update a linked csv file. There are various dates in there already

[Sonyat810]

Here is what I have and all of the dates are today dates
?Datevalue(Date())

[Welshgasman]

First of all Date is a reserved word.
That and Date() is today.
So rename your field something meaningful and use that.

Access is only doing what you are telling it to do.
You do not use the ? either, again that was just to confirm the function result.

[Sonyat810]

My file is too large to upload. Let me make a test database and send it to you so you can see what I'm saying

[Sonyat810]

when I enter =DateValue(myDate()) the name has an error of #Name? in the field

[CJ_London]

Remove the ()

[Sonyat810]

I removed it and it still didn't work. It put parenthesis around "myDate"

[Sonyat810]

I removed the () and I am still getting the timestamp