MS Access

Results 1 to 2 of 2

Thread: MS Access

  1. #1
    Join Date
    Dec 1969

    Default MS Access

    MS Access alert this ERROR<BR><BR>"Function is not aviable in expression in quety expression &#039;Format([dt_predpokladane],"dd/mm/yyyy")&#039;"<BR><BR>where is problem ? thank you

  2. #2
    Join Date
    Dec 1969

    Default RE: MS Access

    it actually *tells* you what is wrong the function in not available in an query.<BR><BR>Use something like this<BR><BR>Sql query: SELECT datefield from table<BR><BR>Response.write FormateDateTime(rs("datefield"),vbShortDate), so use VBscript to format the datevalue.<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