logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


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: 15
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: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 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: 15
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: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
Change the database type to 'Standard' to change the date format.....
Alain  
#5 Posted : Monday, July 6, 2020 10:23:40 AM(UTC)
Alain

Rank: Member

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

sorry it doesn't change anything

The date selection criterion does not work with the Restriction Zone

And if i use STANDARD i can't Use <Click to create a 'Year' and a 'Month' column having Drill navigation>

Thank you for your help

Edited by user Monday, July 6, 2020 1:14:06 PM(UTC)  | Reason: Not specified

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.