| :: European Date format in filter selections :: (4) | Post a New Message | Post a Reply |
 European Date format in filter selections | Post a Reply |
from: MIdlands. UK
I would be grateful if you could answer this quick query. I am using ASP Report Wizard with a SQL Server database. I can use text formatting on the Date field names to display the dates in European DD/MM/YY format but I have to input date selection strings in American MM/DD/YY format in the filter selection boxes, to make filtering on dates work. Is there a Property/Mechanism I can set to switch on to set the European data format as standard?
Many thanks
 Re: European Date format in filter selections | Post a Reply |
from: Washington, DC
You can see the screen shot below:
-------------------------
Ghost
| Re: European Date format in filter selections | Post a Reply |
from: MIdlands. UK
Thanks for the reply. I am already formatting the dates for display in European format using the mechanism you have described. However, if I input a date in European format into the selection box when using the report nothing gets picked up. Please let me explain further below with the following example.
Date in the Database is held in the following format 2004-09-30 21:19:41.000
Date in the field display is formatted to display as DD/MM/YY & displays correctly as 30/9/04
If you input the date in the selection box in the DD/MM/YY format as either 30/9/04 or 30/09/04 no records are returned.
If you input the date in the selection box in the MM/DD/YY format as either 9/30/04 or 09/30/04 then bingo records are selected and displayed.
My question is still the same - is there a setting I can use which allows all the formatting of dates in display and selection conditions to have the European DD/MM/YY date format to be applied as standard? If not, is there a way I can enter a ate in DD/MM/YY format into the seelction box.
Kind regards,
ED
| Re: European Date format in filter selections | Post a Reply |
from: Washington, DC
http://aspwebsolution.com/forums/?tid=942
Let me know if this helps.
-------------------------
Ghost