Announcement

Collapse
No announcement yet.

Limiting date to a particular day of the week.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Thankyou, that is exactly what I was looking for.... I have no idea how it works but it does work, I'll have a play with it and see if I can work out why it works.

    The only issue I'm having now is the date format is yyyy/mm/dd when it should be dd/mm/yyyy locales and any other setting I can think of has been set correctly, is this a database issue or is it something I can adjust somewhere?

    Thanks again to both of you for your help
    Last edited by w33tbix; 06-05-2015, 11:01 PM.

    Comment


    • #17
      Regional settings do not apply to select fields. You have to format the field by yourself.
      Change your statement to:

      Code:
      SELECT 
          wednesdays, DATE_FORMAT(wednesdays,'%d/%m/%Y') 
      FROM
          ...
      jsb

      Comment


      • #18
        you know I had that exact same code in there, I figured the date_format thing out on my own but had it in the wrong spot and gave up till you replied, so thanks again, I'm getting there.

        Comment

        Working...
        X