PROBLIMA ME Access DATE 2 sinexia...

PROBLIMA ME Access DATE 2 sinexia...

Από {christosdev}

Distixos To Problima Den Lithike..
Den doyleyi i FormatDateTime diladi

p.x 'select FormatDateTime(Now()) AS NowFDT From Rev'

Sto PC (WIN 2000) tis doyleia tin sintaso se Query kai doyleyi kanonika .
Sto PC (WIN 98) sto Spiti to idio akribos Pragma Ktipaei.
Distixos Ktipaei Kai Hosting Server to Error einai:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver]
Undefined function 'formatdatetime' in expression.

Ara Den Mporo Na Liso me ' 2057 se UK ' kai 'formatdatetime'
to Problima me tis Imerominies sto Where .
Diladi " Select * from Rev Where DateTo>'1/9/2000' "

Doyleyi sosta Mono gia Imerominies Meta 10/10/2000
To entelos Koyfo einai oti se SElect p.x.
'Select Format(DateTo,"DD mmm yyyy") from Rev'
tote moy emfanizi sosta ton Mera-Mina '01 Oct 2005'

Eyxaristo Poli.

  1. 29/9/2005

    Giati den spas tin hmerominia opws thn amerikanikh? Etsi den xtypaei pote...

    strdate = year(now) & "-" & month(now) & "-" & day(now)

  1. 29/9/2005

    Episis kati poy ksexasa:

    Afoy dimioyrgeis esy to date prosdiorise kathara to erwtimata. px sto paradigma soy prospathise:

    strdate = year(now) & "-" & month(now) & "-" & day(now)

    "SELECT * FROM Rev WHERE DateTo > convert(datetime,'" & strdate & "',102)")

    Den kserw an soy treksei me ACCESS (an kai den katalabainw ton logo na min treksei) alla me MS-SQL trexei perifima...

  1. 3/10/2005

    TELIKA TO ELISA TO PROBLIMA.
    THELI OTI KANIS ME DATE NA TOY DILONIS TIN MORFI POY TO EXEI I BASI KAI MONO.
    PX. DateValue(Format(CheckOut,'MM/DD/YYYY'))

    FISIKA EGO MPORO NA TOY KATEBAZO DATA ME OTI FORMAT EGO THOLO ALLA ME TIN PROOIPOTHESI OTI TOY DILONO PANTA TO FORMAT MOY PX. DateValue(Format(CheckOut,'DD/MM/YYYY')) TO POIO MPORI EINAI DIAFORETIKO APO TO DIKOTOY.

    PX. Select * from Rev Where DateValue(Format(CheckOut,'MM/DD/YYYY')) >DateValue(Format('1/9/2000','DD/MM/YYYY'))

    PROSOSI PREPEI NA DINOYME TO DIKOMAS FORMAT SE INSERT KAI UPDATE

    EYXARISTO POLI .




   Πίσω στην προηγούμενη σελίδα