SQl Server Specific response

[gansr]

Hi,

I am a Newbie to BO and if this is silly and simple pls forgive me.

I have created a few reports and these reports take atwo dates as arguments for the query.

The date format is given as mm/dd/yyyy but now the users need to enter the format as dd/mm/yyyy. How do i achieve this.

I tried changing the format in the Regional Options but still i am getting the error date format returns invalid date range.

My Database is SQL Server my language setting there are US_ENGLISH

Will really appreciate if omebody can give me some solution or useful insights into this problem.

Thanks.

Regards,
Ganesh R

 

[PAULSGS]

Have you the abiity in SQL server to wrap the date up in a format mask? I am an Oracle user and I could do something like this


Select * from Table
Where to_date(tabledatcolumn,dd/mm/yyyy)= '31/01/2002'

What I am suggesting is can you use a built in SQL Server function to alter the format of the date on one side of the equation to agree with the format on the other side of the equation?

 

[gansr]

Hi Paul,

Thanks for the Repsonse.

I am also an oracle user so i was sort of stumped with this SQL Server Stuff.

Anyways there is nothing in sql server like that. I solved this problem by specifying a New LOV which allowed for dd/MM/yyyy.

Thanks once again for the response.

regards,
Ganesh R