using Today as a paramter default 1

[smartglass]

Hi there:
I am trying to write a VFP routine that pulls from MSSQL orders processed today.
Is there any way of defining 'today' as a default parameter in the view?
Also the parameters I use for a similar process elsewhere prompt for a date - which is American style MM/DD/YY. Is it possible for vfp to allow UK style entering of date -eg 13/07/06, recognised by the view as US style 07/13/06?

Thanks from a Brit!

 

[Mike Lewis]

Hi Smarglass,

Is there any way of defining 'today' as a default parameter in the view?

Use GETDATE() in your WHERE clause. This is equivalent to VFP's DATETIME().

Be aware that dates in SQL Server are in fact stored as datetimes.

Also the parameters I use for a similar process elsewhere prompt for a date - which is American style MM/DD/YY. Is it possible for vfp to allow UK style entering of date

Not sure exactly what you mean. Issuing SET DATEFORMAT dmy tells SQL Server to interpret date literals in standard format (as opposed to American). Does that help?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk