DAYOFMONTH[ ] problem

[ascikey]

seems to be a problem with my syntax, i am trying to return the day of the month that is in the field last_enter_date where the remote_ip field is = '127.0.0.1'

SELECT  DAYOFMONTH[last_enter_date] FROM ip_addresses WHERE remote_ip = '127.0.0.1'

any help appreciated
thx Tony

 

[KarveR]

DAYOFMONTH(date_field)

not square brackets

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[ascikey]

Thanks for pointing that out, it was rather late when I was doing it but even when i came back to it today i still didn’t see it

 

[ascikey]

try removing the null because as far as i am aware u only say if it is NOT NULL
if that dosent work let me know and i will make the table

 

[ascikey]

sorry wrong post