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
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
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
Its not showing the date at all in my csv file now
And all of the records show today date
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I'm not good at this yet. Can you tell me what to put there
the name of your timestamp field
I am assuming you are exporting a query and not a table
My field is called Date field. I am trying to update a linked csv file. There are various dates in there already
Here is what I have and all of the dates are today dates
?Datevalue(Date())
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.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
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
when I enter =DateValue(myDate()) the name has an error of #Name? in the field
Remove the ()
I removed it and it still didn't work. It put parenthesis around "myDate"
I removed the () and I am still getting the timestamp