Split date in day, month and year inside query (1 Viewer)

[gstylianou]

I need a query so to split the date 18/01/2023 to day=18 , month=01 and year=2023 within query. Can anyone help?

 

[Gasman]

Yes. Use the functions that have those exact names?

 

[gstylianou]

Yes. Use the functions that have those exact names?

The table name is Dates, the date as above field is the [Month_Date] which is date format (short date)

How can i split it?

 

[arnelgp]

as in post #2:

copy/paste to query designer (SQL view):

Select Day([Month_Date]) As D, Month([Month_Date]) As M, Year([Month_Date]) As Y From Dates

 

[gstylianou]

Thank you very much, working fine. Another one question,

I'm trying to make time table with time slots every 15min Starting from 00:00 Ends On 23:45. If there is a way to do it using vba?

 

[arnelgp]

i create TimeT table and from that table created TimeSlotQ query.

 

[Minty]

Create a lookup table with the time slots in it.

Having the slots in a table will make you life much easier.
You can probabaly create in excel using autofill and paste them in.

 

[gstylianou]

Create a lookup table with the time slots in it.
View attachment 107102 View attachment 107103

Having the slots in a table will make you life much easier.
You can probabaly create in excel using autofill and paste them in.

Thanks, i already did it

 

[gstylianou]

Is there is a way to take the day name using sql query? Lets say today is 23/03/2023 to take Thursday?

 

[gstylianou]

i create TimeT table and from that table created TimeSlotQ query.

Really thanks

 

[Gasman]

Is there is a way to take the day name using sql query? Lets say today is 23/03/2023 to take Thursday?

I have Google on this phone.

Day Name from Date

I have a report on which I have two unbound text boxes that I want to populate with the dayname for a related date. One is called txtStartDateName, and the other...... yep, you guessed it, its txtEndDateName txtStartDate name Control Source is: =WeekdayName(Weekday([txtStartDate])) With...

www.access-programmers.co.uk

Found via

get weekday name from date accessed vba - Google Search