Forum

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.

Απάντηση από:Aseos

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

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

Απάντηση από:Aseos

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...

Απάντηση από:christosdev

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 .