Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear sir



i have a query select enqdate from tblsenq where id=100
and after that i bind the ms flex grid like
set grid=data source=record set
but the date shows in format like 2014-03-12-00:00:00
i want only date in 12-03-2014 format please tell me wt i have to do
Posted

1 solution

Have you searched it?[^]

If so, you could have found this[^]

And come up with this?
VB
Format(Now, "dd/MM/yyyy")
Format(Date, "dd/MM/yyyy")
Format(CStr(Now), "dd/MM/yyyy")
Format(Date$, "dd/MM/yyyy")
Format(CDate(Date), "dd/MM/yyyy")
 
Share this answer
 
Comments
rajbir singh thind 31-Mar-14 3:39am    
When i use all these functions in query it shows error expected list operator required
Format(Now, "dd/MM/yyyy")
Format(Date, "dd/MM/yyyy")
Format(CStr(Now), "dd/MM/yyyy")
Format(Date$, "dd/MM/yyyy")
Format(CDate(Date), "dd/MM/yyyy")
rajbir singh thind 31-Mar-14 3:40am    
i binding the grid direct not one by one
Orcun Iyigun 31-Mar-14 4:10am    
Do it on the DB side? Which DB you are using?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900