1 Topic by negadi37 (edited by negadi37 2022-04-19 18:46:29)

  • Registered: 2022-04-19
  • Posts: 24

Topic: Separation of days for a period of time

please i need help how to do that in MVD

Post's attachments

Attachment icon Capture d’écran 2022-04-19 191944.png 74.81 kb, 91 downloads since 2022-04-19 

2 Reply by sibprogsistem (edited by sibprogsistem 2022-04-19 20:34:13)

  • From: Нефтеюганск
  • Registered: 2018-04-11
  • Posts: 1,775

Re: Separation of days for a period of time

negadi37 wrote:

please i need help how to do that in MVD

   
 
video
https://youtu.be/t9QC42nKOJI
   
file

Post's attachments

Attachment icon sqlite.zip 2.99 kb, 163 downloads since 2022-04-19 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,814

Re: Separation of days for a period of time

Hi Negadi, Hi Sibprogsistem,

It's hard to say without seeing your project (specifically your data structure).
If you can zip your project (without the .exe file) it would help.
But have a look at the attached which may give you some ideas (but there are probably other ways too).
Regards,
Derek

Post's attachments

Attachment icon negadi.zip 374.71 kb, 174 downloads since 2022-04-19 

4 Reply by negadi37 (edited by negadi37 2022-04-19 21:40:40)

  • Registered: 2022-04-19
  • Posts: 24

Re: Separation of days for a period of time

derek wrote:

Hi Negadi, Hi Sibprogsistem,

It's hard to say without seeing your project (specifically your data structure).
If you can zip your project (without the .exe file) it would help.
But have a look at the attached which may give you some ideas (but there are probably other ways too).
Regards,
Derek

thnks mr Drek but not like that i want just to show the days between a period in a table grid exmp:

from 01/04/2022 to 05/04/2022
01/04/2022
02/04/2022
03/04/2022
04/04/2022
05/04/2022

  • Registered: 2022-04-19
  • Posts: 24

Re: Separation of days for a period of time

sibprogsistem wrote:
negadi37 wrote:

please i need help how to do that in MVD

   
   
file

thnks for your effort but not like that i to show all the date between not only the first date and the last one
exmp:
from 01/04/2022 to 05/04/2022
01/04/2022
02/04/2022
03/04/2022
04/04/2022
05/04/2022

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,814

Re: Separation of days for a period of time

Hi,
So what you want is to filter a tablegrid by 'from' and 'to dates.
Have a look at the attached - you can filter by date and by trip;  when you filter by trip, you can either use the combobox to select a trip or click in the trip tablegrid (and obviously you can use any combination of trip value and date values).
Derek.

Post's attachments

Attachment icon negadi 2.zip 374.29 kb, 192 downloads since 2022-04-20 

  • Registered: 2022-04-19
  • Posts: 24

Re: Separation of days for a period of time

derek wrote:

Hi,
So what you want is to filter a tablegrid by 'from' and 'to dates.
Have a look at the attached - you can filter by date and by trip;  when you filter by trip, you can either use the combobox to select a trip or click in the trip tablegrid (and obviously you can use any combination of trip value and date values).
Derek.

no its not a filter its a date feild start date and end date i want to show all date between
same like in the picture

Post's attachments

Attachment icon Capture d’écran 2022-04-19 191944.png 74.81 kb, 101 downloads since 2022-04-20 

  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 431

Re: Separation of days for a period of time

Maybe something like this might help you.

Post's attachments

Attachment icon datebetween.zip 552.19 kb, 196 downloads since 2022-04-20 

brian