Rank: Member
Groups: Registered
Joined: 1/30/2020(UTC) Posts: 15 
|
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
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  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 ?
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 1/30/2020(UTC) Posts: 15
|
Hello
My base is DB2
But I go through a table attached to Access
What is the solution?
thank you so much
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Change the database type to 'Standard' to change the date format.....
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 1/30/2020(UTC) Posts: 15
|
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
|
|
|
|
|
|
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.
