By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,536 Members | 1,800 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,536 IT Pros & Developers. It's quick & easy.

Formatting Datetime Field into Date column and Time column

P: n/a
I am trying to display my verified_datetime field into 2 different
columns (1 for Date, and 1 for Time). Using this query returns
nothing.

Format ([verified_datetime], "mm/dd/yy") AND
Format ([verified_datetime], "hh:mm")

I then would like to filter anything between the hours of 5:00 PM and
8:00 AM but am hitting a roadblock there as well. Any help would be
greatly appreciated.

Jan 17 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
dot
Where are you writing this? In the query editor or in code?
twin_mother wrote:
I am trying to display my verified_datetime field into 2 different
columns (1 for Date, and 1 for Time). Using this query returns
nothing.

Format ([verified_datetime], "mm/dd/yy") AND
Format ([verified_datetime], "hh:mm")

I then would like to filter anything between the hours of 5:00 PM and
8:00 AM but am hitting a roadblock there as well. Any help would be
greatly appreciated.
Jan 17 '07 #2

P: n/a
I've tried both Designer and SQL Views.

On Jan 17, 10:58 am, dot <"bas(nospam)wanders(dot)net"wrote:
Where are you writing this? In the query editor or in code?

twin_mother wrote:
I am trying to display my verified_datetime field into 2 different
columns (1 for Date, and 1 for Time). Using this query returns
nothing.
Format ([verified_datetime], "mm/dd/yy") AND
Format ([verified_datetime], "hh:mm")
I then would like to filter anything between the hours of 5:00 PM and
8:00 AM but am hitting a roadblock there as well. Any help would be
greatly appreciated.- Hide quoted text -- Show quoted text -
Jan 17 '07 #3

P: n/a
SELECT verified_datetime, Format([verified_datetime],"mm/dd/yy") AS
DatePart,
Format([verified_datetime],"Short Time") AS TimePart
FROM tbldatetime
WHERE Hour([verified_datetime]) Between 8 And 17;

Cheers,
Jason Lepack

twin_mother wrote:
I've tried both Designer and SQL Views.

On Jan 17, 10:58 am, dot <"bas(nospam)wanders(dot)net"wrote:
Where are you writing this? In the query editor or in code?

twin_mother wrote:
I am trying to display my verified_datetime field into 2 different
columns (1 for Date, and 1 for Time). Using this query returns
nothing.
Format ([verified_datetime], "mm/dd/yy") AND
Format ([verified_datetime], "hh:mm")
I then would like to filter anything between the hours of 5:00 PM and
8:00 AM but am hitting a roadblock there as well. Any help would be
greatly appreciated.- Hide quoted text -- Show quoted text -
Jan 17 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.