DateFormat

  • Thread starter Thread starter Catalin Lungu
  • Start date Start date
C

Catalin Lungu

Hi,
How can I change the date format for an .sdf file from mm/dd/yy to dd/mm/yy.
I receive data from SQL Server to a PDA. The format date to SQL Server is
dd/mm/yy and I like to work with this format.

Thanks in advance,
Catalin
 
The way the dates are displayed are depending of the language or culture
settings.
You can manualy change the display by choosing a iFormatprovider or a string
to pass in oDatetime.ToString

In my code it looks like this:

oControl:Text := oRSForm:GetDateTime(cControl ):ToString('dd-MM-yyyy')

hth,

Erik Visser
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook macro for specific email 0
How to enter a date in DD-MM-YYYY format 2
date format 2
Preserving date format 1
Finding Date in an overseas format 20
Access Template "Accounts Ledger database" 5
Change date format in Excel footer 2
date format 1

Back
Top