|

»

date member order & presentation

View: New views

5 Messages — Rating Filter: Alert me

	date member order & presentation by Jean-Yves F. Barbier-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi, I use a postgresql database, and I need to display dates (in a modified TableView) according to DB (ISO: yyyy-mm-dd, with separator '-', not '/'), otherwise it displays 10/11/2009, but waits for an input such as 2009-11-10 when I search. How can I do that? -- A door is what a dog is perpetually on the wrong side of. -- Ogden Nash ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@... https://lists.sourceforge.net/lists/listinfo/gambas-user
	Re: date member order & presentation by jacky-12 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Jean-Yves F. Barbier a écrit : > Hi, > > I use a postgresql database, and I need to display dates (in a modified > TableView) according to DB (ISO: yyyy-mm-dd, with separator '-', not '/'), > otherwise it displays 10/11/2009, but waits for an input such as 2009-11-10 > when I search. > > How can I do that? > Format$(Yourdate, "yyyy-mm-dd") ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@... https://lists.sourceforge.net/lists/listinfo/gambas-user
	Re: date member order & presentation by Fabien Bodard-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 2009/11/10 Jean-Yves F. Barbier <12ukwn@...>: > Hi, > > I use a postgresql database, and I need to display dates (in a modified > TableView) according to DB (ISO: yyyy-mm-dd, with separator '-', not '/'), > otherwise it displays 10/11/2009, but waits for an input such as 2009-11-10 > when I search. > > How can I do that? > are you using the gambas db type Date ?. > A door is what a dog is perpetually on the wrong side of. > -- Ogden Nash > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Gambas-user mailing list > Gambas-user@... > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@... https://lists.sourceforge.net/lists/listinfo/gambas-user
	Re: date member order & presentation by Jean-Yves F. Barbier-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Fabien Bodard a écrit : > 2009/11/10 Jean-Yves F. Barbier <12ukwn@...>: >> Hi, >> >> I use a postgresql database, and I need to display dates (in a modified >> TableView) according to DB (ISO: yyyy-mm-dd, with separator '-', not '/'), >> otherwise it displays 10/11/2009, but waits for an input such as 2009-11-10 >> when I search. >> >> How can I do that? >> > > are you using the gambas db type Date ?. No, it is to format display in the code you gave me :) -- real buddy, n.: Someone who'll go downtown and get two blowjobs, and come back and give you one. ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@... https://lists.sourceforge.net/lists/listinfo/gambas-user
	Re: date member order & presentation by Fabien Bodard-4 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 2009/11/10 Jean-Yves F. Barbier <12ukwn@...>: > Fabien Bodard a écrit : >> 2009/11/10 Jean-Yves F. Barbier <12ukwn@...>: >>> Hi, >>> >>> I use a postgresql database, and I need to display dates (in a modified >>> TableView) according to DB (ISO: yyyy-mm-dd, with separator '-', not '/'), >>> otherwise it displays 10/11/2009, but waits for an input such as 2009-11-10 >>> when I search. >>> >>> How can I do that? >>> >> >> are you using the gambas db type Date ?. > > No, it is to format display in the code you gave me :) ok so the format function is the good one Thanks Jack ;) > > -- > real buddy, n.: > Someone who'll go downtown and get two blowjobs, and come back > and give you one. > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Gambas-user mailing list > Gambas-user@... > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@... https://lists.sourceforge.net/lists/listinfo/gambas-user