Link to home
Start Free TrialLog in
Avatar of garyz31
garyz31

asked on

Formating dates in interdev

What control can I bind to a datetime database field using RDS so that I can control the format of the displayed data.  I am using a Textbox control, but I am getting a display of a full datetime value, I want to display a short date value.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of moehler
moehler
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of garyz31
garyz31

ASKER

Am I correct in inferring that I can fix the problem by changing settings on the SQL Server?
Avatar of moehler
moehler
Having not worked with SQL Server, I don't know, but if you are attempting to format to a certain dateformat, the formatDateTime does work.
Avatar of garyz31
garyz31

ASKER

formatDateTime Does work, but if control CTL is bound to table field tbl.DateReceived, then I think I have to copy the value to an unbound control in order to use that function.  Sumething like CTL2 = formatDateTime(...)

I was hoping to have the ability to specify the format used by the bound control.

Please correct me if I have misunderstood your suggestion.

Thanks