Format(Date, "MM/DD/YYYY")

[Sabina]

Hello,

How can I porting this code

to_date('" & Format(Date, "MM/DD/YYYY") & "','mm/dd/yyyy')

from VB to aspx?

SelectCommand="SELECT * FROM tbl_Products
WHERE tbl_Products.ProductStartDate <= to_date('" & Format(Date, "MM/DD/YYYY") & "','mm/dd/yyyy')"

Thanks,Sabina

[kenobewan]

Format(Date, "MM/DD/YYYY")

[Sabina]

Hello,

I don't undestand.
I can't replace

to_date('" & Format(Date, "MM/DD/YYYY") & "','mm/dd/yyyy') (from VB) to
Format(Date, "MM/DD/YYYY")

How can I port to_date('" & Format(Date, "MM/DD/YYYY") & "','mm/dd/yyyy') from VB to asp.net?




Thanks,Sabina

[digitalmanic]

Sabina,

The below link explains all date formating. Check it.

http://msconline.maconstate.edu/tuto...bnet01-08.aspx



Ambika Praveen.

[Sabina]

I get the error message :"Cannot switch views:(validation (asp.net):If this attribute value is enclosed in quotation marks,the quotation marks must match.


SelectCommand="SELECT Product_Code, Product_ID FROM tbl_Employees,tbl_Factories,tbl_Product_categories ,tbl_Products
WHERE tbl_Factories.Factory_ID = tbl_Product_categories.Factory_ID
AND tbl_Product_categories.Product_category_ID = tbl_Products.Product_category_ID
AND tbl_Employees.Employee_ID = tbl_Product_categories.Product_category_Manager_ID
AND tbl_Products.ProductStartDate <= to_date('" & Format(Date, "MM/DD/YYYY") & "','mm/dd/yyyy')"

If I close SelectCommand
SelectCommand="SELECT Product_Code, Product_ID FROM tbl_Employees,tbl_Factories,tbl_Product_categories ,tbl_Products
WHERE tbl_Factories.Factory_ID = tbl_Product_categories.Factory_ID
AND tbl_Product_categories.Product_category_ID = tbl_Products.Product_category_ID
AND tbl_Employees.Employee_ID = tbl_Product_categories.Product_category_Manager_ID "

without the last line I getn't the errors.


Thanks,Sabina

[Sabina]

Hello,

How can I port >= ?


Thanks,Sabina

[kenobewan]

I suggest placing the datetime in a variable first, formatting the date and then using it in your select statement. You have already debugged and established the problem, now take this further. Display the variable if it is still not working to see why it might not work...