Results 1 to 5 of 5
  1. 06-09-2020, 01:43 AM #1
    anvs
    anvs is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    3

    A que dias numéricos da semana correspondem as datas dos registos?

    Viva!



    Tenho uma Tabela com um campo DtVisita onde são escritas as datas no formato dd/mm/aaaa.
    Necessito do código SQL para criar uma Consulta que me devolva, para cada data registada, o correspondente número do dia nessa semana.
    Exemplo:
    1 se for domingo
    2 se for 2ª feira
    ...
    ...
    7 se for sábado.

    Antecipadamente agradecido.
    anvs

    Nota:
    Coloquei a questão em MáximoAccess mas ainda não possibilidade de resposta.
    como tenho alguma urgência em resolver esta situação, recorri a este fórum.
    Reply With Quote Reply With Quote
  2. 06-09-2020, 03:04 AM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Veja a função Weekday ()
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  3. 06-09-2020, 03:27 AM #3
    anvs
    anvs is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    3
    Quote Originally Posted by Bob Fitz View Post
    Veja a função Weekday ()
    O que necessito é do código SQL para a query devolver o número do dia da semana.
    Obrigado
    anvs
    Reply With Quote Reply With Quote
  4. 06-09-2020, 05:35 AM #4
    orange's Avatar
    orange
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    See https://www.techonthenet.com/access/...te/weekday.php


    WeekDay(DtVisita)
    AccessFunctions_SyntaxAndExamples TechontheNet
    M$oftVBA Function Details
    Debugging VBA and Error Handling
    Links to articles re Database Planning and Design
    DataPig Videos Revived DataPig Queries
    DataPig Form Basics
    Reply With Quote Reply With Quote
  5. 06-09-2020, 06:21 AM #5
    anvs
    anvs is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2020
    Posts
    3

    A que dias numéricos da semana correspondem as datas dos registos?

    Quote Originally Posted by orange View Post
    See https://www.techonthenet.com/access/...te/weekday.php


    WeekDay(DtVisita)
    PERFEITO!

    Muito obrigado.
    anvs
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. The best way to store datas in access database
    By atzdgreat in forum Access
    Replies: 5
    Last Post: 09-15-2019, 06:07 AM
  2. pulling datas from the table in the form
    By tamilarasi in forum Forms
    Replies: 11
    Last Post: 05-12-2014, 05:33 AM
  3. Save datas in the table
    By monica in forum Programming
    Replies: 2
    Last Post: 04-13-2012, 07:03 AM
  4. select datas where equal to the max
    By rbg in forum Queries
    Replies: 0
    Last Post: 03-28-2011, 12:38 PM
  5. Manipulating datas on access table
    By 3rdeye in forum Access
    Replies: 6
    Last Post: 10-12-2010, 02:47 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums