How to remove the timestamp from date field

[Sonyat810]

Now I am getting a #Type! error

[Sonyat810]

getting a #Type! error

[Welshgasman]

You need to show what that DateValue is using in the ControlSource?
If Mydate, then I would have thought you need to use another name for the control?, otherwise confusing as hell.

Just upload the DB as requested in post #16 please, this is at 32 posts and we have got absolutely nowhere.

[Sonyat810]

Here is what I have

[Welshgasman]

Here is what I have

And detailed instructions?

Edit: Table is linked, so no good to anyone except you.
Import it into the DB and upload again.

You do not want to change your date format in Access, just when you export to BI?, so need to see how that is carried out?

[Sonyat810]

Here is what I have

[Welshgasman]

I changed the field to LiquidDate as you still had it as Date?, so MyDate was never going to work.
You will get an error when you add a new record as the date field will not have a value.

However I thought this saga was all about getting rid of the time element from a field so as to export to BI.?

You have no time elements in what you uploaded?

[Welshgasman]

Ok, it has finally sunk in what is happening.
There are no time elements in your date field, Access itself adds them as 00:00:00 when you export. :(

So you need to find out what format BI expects dates to be in and format to that format. A quick google shows that people recommend importing as text and then creating a date from that?
However I would certainly look to see how BI expects a date when importing.

You are on your own with BI. :)

[ssanfu]

Suggestions:
Object names should be letters and numbers.
Do not begin an object name with a number.
NO spaces, punctuation or special characters (exception is the underscore) in object names (Field, Table, Query and Form names)

Bad field name: "Liquid Amount (Gallons)" AND has spaces
Better: "Liquid_Amount_Gallons" or "LiquidAmountGallons"

[Welshgasman]

Also why the csv route?
Apparently PBI can link/import just like Access?
https://www.google.com/search?client...rt+from+access

[Welshgasman]

FWIW I downloaded PBI Desktop and used it to access your TestDB
It appears to only recognise tables, so you would need to create one for your output.?

However it is vey slow on my old laptop, so I left it to go and get a passenger.
When I returned, no error message.
I have no clue how to see that data in PBI, but it appears to have been imported/linked without any issues?

So perhaps try Access direct? You have to click on the More option to see Access database.

[Sonyat810]

Ok I will try this

[Welshgasman]

Ok I will try this

Crossposting the same query after 30 plus posts, is not what I would call 'ok, I will try this'

https://www.accessforums.net/showthread.php?t=86422

[Sonyat810]

Sorry, I didnt mean to cross post but I sense your patience is running thin with so many post. Just trying to figure this out.

[Micron]

Maybe what's needed is a higher level description of what you are doing and what the outcome needs to be. So far, this seems to be like
"I need to do B. I have already done/set up A"
Sometimes the problem is really A and there is a better way that avoids having to do B. Can you provide a description of the process involved in this data management?
Might be a good idea to mark the other thread as solved so that people who are unaware of this one don't start asking questions in the other one? Then we can see where your description takes this. It may very well be that a new thread is warranted, but I'd say not until we know more about the process.