5 replies to this topic

[avosoft]

Hello guy!

AM doing a query against database, but its not working

sSQL = "SELECT * FROM tasks WHERE due_date = " & MakeUSDate(Now) & _

    " AND due_time < " & MakeUSTime(Time)

The date and time function

' Make US date and time


Function MakeUSDate(X As Variant) As String

    If Not IsDate(X) Then Exit Function

    MakeUSDate = "#" & Month(X) & "/" & Day(X) & "/" & Year(X) & "#"

End Function


Function MakeUSTime(X As Variant) As String

    If Not IsDate(X) Then Exit Function

    MakeUSTime = "#" & Hour(X) & ":" & Minute(X) & ":" & Second(X) & "#"

End Function

any help here!:)

[WingedPanther]

What type of database are you running this against? Depending on the type, you may need to delimit the date with single quotes, hash marks, or something else.

[avosoft]

Hello,

Am ruining it against Ms Access

[WingedPanther]

http://msdn.microsof...%28SQL.90).aspx

[avosoft]

Thanks for your response i found out that is was the way i saved my date and time in access database.
i changed the time to datatype mediumtime and date to short date i also used this to format time Format$(time,"h:nn AM/PM")

[WingedPanther]

I'm glad I could help :)