Date placeholder

[axapta]

Hi
I need the input of a text field to be as dd/mm/yyyy how can I achieve this?

Regards

 

[rowe_newsgroups]

Hi
I need the input of a text field to be as dd/mm/yyyy how can I achieve this?

Regards

Simple:

Don't allow the user to directly enter text into the text box and give
them a calender control to pick the date from.

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/

 

[Miro]

If you really wanted to use a textbox,

could you not use a formatted box and then validate the numbers against a
date command.
If the date command works - its a valid date. If not - its not.

Miro

 

[Family Tree Mike]

A MaskedTextBox or a DateTimePicker support this. You just need to set the
appropriate formatting options on each.

 

[Cor Ligthert[MVP]]

Axapta,

A web textbox or a windows form textbox, because the approach to that can be
different?

Cor

 

[axapta]

OK, I implemented a calendar control. The problem seems to be in
configuration.
If I enter 07/06/2005 as a date, the results returned by the SQL SP are
records which match 06/07/2005.

I've set the language to British on the SQL Server ...

 

[Cor Ligthert[MVP]]

Axapta,

But what is on your your client? As SQL server simple returns a DateTime,
independent from the setting on the Server.

I assume that you use parameters to select that.

http://www.vb-tips.com/SQLParameters.aspx

Cor

 

[Herfried K. Wagner [MVP]]

I need the input of a text field to be as dd/mm/yyyy how can I achieve
this?

In addition to the other replies: Note that different countries, languages,
and cultures use different date and time formats. Thus it does not make
much sense to tie the user to a certain date format which he is maybe not
familiar to.