Forums
This topic is locked
Query with Current Month
Posted 03 Jan 2002 18:25:03
1
has voted
03 Jan 2002 18:25:03 Paul Gowder posted:
In UltraDev, how can I do a query to pull results based on matching a month field to the current date??Replies
Replied 03 Jan 2002 18:41:52
03 Jan 2002 18:41:52 Owen Eastwick replied:
Someting like:
RecordsetName.Source = "SELECT Whatever, WhateverElse, AndTheRest FROM YourTable WHERE DatePart('m', YourDateField)= DatePart('m'," & Now() & "
"
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Edited by - oeastwick on 03 Jan 2002 18:44:28
RecordsetName.Source = "SELECT Whatever, WhateverElse, AndTheRest FROM YourTable WHERE DatePart('m', YourDateField)= DatePart('m'," & Now() & "
"Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Edited by - oeastwick on 03 Jan 2002 18:44:28
Replied 03 Jan 2002 18:49:07
03 Jan 2002 18:49:07 Paul Gowder replied:
Can that be done through the gui??
Replied 03 Jan 2002 18:50:08
03 Jan 2002 18:50:08 Paul Gowder replied:
I'm coding in PHP with phakt, also.
Replied 03 Jan 2002 22:59:46
03 Jan 2002 22:59:46 Owen Eastwick replied:
Can that be done through the gui?? - Probably not.
I'm coding in PHP with phakt, also. - You never said, try posting in the PHP section.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
I'm coding in PHP with phakt, also. - You never said, try posting in the PHP section.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo