1 Topic by foevil (edited by foevil 2023-09-16 19:22:01)

  • Registered: 2023-09-14
  • Posts: 55

Topic: how to fix TableGrid Order Date Issue Please Help

how to fix TableGrid Order Date Issue Please Help Urgent

https://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=9891&download=0

Post's attachments

Attachment icon Screenshot 2023-09-17 004009.png 13.25 kb, 13 downloads since 2023-09-16 

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

Re: how to fix TableGrid Order Date Issue Please Help

From your screen capture, I assume you are using two fields - a date field and a time field.
To sort a tablegrid on 2 or more columns, use the 'order by' option and then specify, in order, the fields you want to sort on  (see the screenshot).
My question would be what is your rationale behind using a date AND a time field rather than simply using a date/time field?

Post's attachments

Attachment icon screenshot.jpg 84.49 kb, 17 downloads since 2023-09-16 

  • Registered: 2023-09-14
  • Posts: 55

Re: how to fix TableGrid Order Date Issue Please Help

derek wrote:

From your screen capture, I assume you are using two fields - a date field and a time field.
To sort a tablegrid on 2 or more columns, use the 'order by' option and then specify, in order, the fields you want to sort on  (see the screenshot).
My question would be what is your rationale behind using a date AND a time field rather than simply using a date/time field?



Thanks Bro <3