General information
Category:
Coding, syntax & commands
Hello Ed, Jeff
Thank You
Gomonth()
I will remember that one!
Thanks Again!!
R D Black
>>I'm trying to scan a date field for records that are in the month of may 1999 is there a function or comgination of functions to do this?
>>
>
>several ways to do this - I'd use BETWEEN(), as in:
>
>dBeginDate = {^1999-06-01}
>dEndDate = GOMONTH(dBeginDate,1) - 1
>
>SCAN FOR BETWEEN(dMyDateFld, dBeginDate, dEndDate)
>
>an index on dMyDateFld will help performance significantly here.
>
>You could also use DTOS():
>
>cMonthToFind = LEFT(DTOS(dBeginDate),6)
>
>SCAN FOR DTOS(dMyDateFld) = cMonthToFind
>
>an index on DTOS(dMyDateFld) will help performance significantly here.
>>Any Help will be greatly appreciated!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only