Page 2 of 4 FirstFirst 1234 LastLast
Results 16 to 30 of 54
  1. #16
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858

    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

  2. #17
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    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

  3. #18
    Sonyat810 is offline Advanced Beginner
    Windows 7 64bit Office 365
    Join Date
    May 2022
    Posts
    37

    My data still has the timestamp

    My data still has the timestamp
    Attached Thumbnails Attached Thumbnails Capture2.PNG  

  4. #19
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    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

  5. #20
    Sonyat810 is offline Advanced Beginner
    Windows 7 64bit Office 365
    Join Date
    May 2022
    Posts
    37
    =DateValue([myDate])
    Attached Thumbnails Attached Thumbnails Capture3.PNG  

  6. #21
    Sonyat810 is offline Advanced Beginner
    Windows 7 64bit Office 365
    Join Date
    May 2022
    Posts
    37
    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

  7. #22
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    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

  8. #23
    Sonyat810 is offline Advanced Beginner
    Windows 7 64bit Office 365
    Join Date
    May 2022
    Posts
    37
    Yes it has to be an actual date. When I use datevalue it changes all the previous dates to today

  9. #24
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Quote Originally Posted by Sonyat810 View Post
    Yes it has to be an actual date. When I use datevalue it changes all the previous dates to today
    That is just because you are not doing it correctly, nothing else.
    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

  10. #25
    Sonyat810 is offline Advanced Beginner
    Windows 7 64bit Office 365
    Join Date
    May 2022
    Posts
    37
    Isn'tthis the correct way
    =DateValue([myDate])

  11. #26
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    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

  12. #27
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    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

  13. #28
    Sonyat810 is offline Advanced Beginner
    Windows 7 64bit Office 365
    Join Date
    May 2022
    Posts
    37
    myDate is the name of the Date field. I also used expression builder

  14. #29
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    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

  15. #30
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    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.
    Attached Thumbnails Attached Thumbnails qbe.JPG   qbe output.JPG  
    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

Page 2 of 4 FirstFirst 1234 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Timestamp converted to just date
    By Lisa Roby in forum Queries
    Replies: 12
    Last Post: 03-24-2020, 07:41 PM
  2. Replies: 8
    Last Post: 11-16-2017, 03:07 PM
  3. Replies: 6
    Last Post: 06-30-2017, 02:15 PM
  4. Replies: 6
    Last Post: 04-19-2016, 03:58 PM
  5. Replies: 3
    Last Post: 11-12-2014, 05:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums