logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Alain  
#1 Posted : Thursday, June 25, 2020 1:44:37 PM(UTC)
Alain

Rank: Member

Groups: Registered
Joined: 1/30/2020(UTC)
Posts: 13
France

Hello
I have a problem with the date format
My data is in Date format but when I put it in a choice list I get an error message
dates in dd / mm / yyyy
format become numbers

WHERE (Requete_OF.DATE_OF BETWEEN 43831 AND 44007)

And in my choice List i can't Use Between ...........
What is the solution?

thank you so much
javascript:__doPostBack('forum$ctl03$PostReply','')

Edited by user Friday, June 26, 2020 11:52:43 AM(UTC)  | Reason: Not specified

epf  
#2 Posted : Saturday, June 27, 2020 3:28:42 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 915
Switzerland

Thanks: 14 times
Was thanked: 153 time(s) in 147 post(s)
The Date Time format specified in the connection is not used if your Database Type is MS Access...
are you sure of your database type ?
Alain  
#3 Posted : Monday, June 29, 2020 8:21:55 AM(UTC)
Alain

Rank: Member

Groups: Registered
Joined: 1/30/2020(UTC)
Posts: 13
France

Hello
My base is DB2
But I go through a table attached to Access
What is the solution?
thank you so much

epf  
#4 Posted : Monday, June 29, 2020 3:23:51 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 915
Switzerland

Thanks: 14 times
Was thanked: 153 time(s) in 147 post(s)
Change the database type to 'Standard' to change the date format.....
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.