**** Annoying Dates

Results 1 to 2 of 2

Thread: **** Annoying Dates

  1. #1
    Join Date
    Dec 1969

    Default **** Annoying Dates

    I have used to following code to give me the start of the week<BR><BR>dtmStartOfWeek = Date() - weekday(date(), vbMonday) + 1<BR><BR>however dtmStartOfWeek has the date stores as US-English date format and this is proving a problem when using this value in my SQL queries. Does anyone know of a way I can get the UK-English date format for the start date of the week (i.e dd/mm/yyyy instead of mm/dd/yyyy)

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default use the dataadd function

    instead of the +1<BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts