We are going to be here all week and more like this.
Create a new db, and copy in just what is needed to see the issue. Give detailed instructions on how to replicate the issue. Compact, zip and upload.
We are going to be here all week and more like this.
Create a new db, and copy in just what is needed to see the issue. Give detailed instructions on how to replicate the issue. Compact, zip and upload.
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
You do not put it as criteria, you put it as an expression. Put datevalue(date) on the first line. Better to change that name as I have already advised.
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 data still has the timestamp
So upload the db
Why are some showing no time element?
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
=DateValue([myDate])
Thats what im trying to figure out. I think because the csv file doesnt support date and time so when I upload it in Power bi there is no date
The field has to be an actual date, not just look like one?
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
Yes it has to be an actual date. When I use datevalue it changes all the previous dates to today
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
Isn'tthis the correct way
=DateValue([myDate])
A date in access/excel is just a number. If exported as sich and YOU tell bi that it is a date, then it should come in as a date?
Seems lots of people have trouble with importing dates into bi?
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
Only if mydate is the name of your field and it does not hold today's date.
We are going around in circles here and getting nowhere.
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
myDate is the name of the Date field. I also used expression builder
In post 15 you are using =DateValue(MyDate) as criteria
Even if it was criteria, you would not use the = sign.
Same with the expression
you just need DateValue(MyDate] in the top line of the QBE window. ACcess will then insert Expr1: in front of that. That is the alias it will give to this expression/new field.
You can change Expr1: to ExportDate: or whatever you want.
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
Here I had done the opposite and added the timevalue of now() to any date in the table.
I do not have any tables I can find that has the time element.
Logic is the same though.
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