vb 6.0中的日期过滤 [英] date filtering in vb 6.0

问题描述

先生
我正在尝试使用ms mdb数据库，vb 6.0作为界面在日期中进行过滤

我输入了代码
从purchace中选择*，其中pur_date =#&dtpicker1.value&"#"
但不能过滤

我看到了数据库
我的数据存储类似dd/mm/yyyy格式

然后我再次在工作的界面中尝试使用mm/dd/yyyy格式

请帮助我
我该如何解决此问题，我的主要语言设置是美国，日期为dd/mm/yyyy

ravi

sir
i am tring to filter in date using ms mdb database, vb 6.0 as interface

i put code
select * from purchace where pur_date=#" & dtpicker1.value & "#"
but cant filter

i see the database
my data stores like dd/mm/yyyy format

and i again try like mm/dd/yyyy format in interface that was working

please help me
how can i solve this problem, my reginal language setting was u.s, date dd/mm/yyyy

ravi

推荐答案

Visual Studio不支持VB6，因为它已过时且已过时.请正确标记您的问题.您的数据库是否只存储日期或时间?我猜想您需要在当天的12:01到11:59 pm之间进行搜索.

Visual Studio does not support VB6, because it is obsolete and out of date. Please tag your question properly. Is your database storing only dates, or times as well ? I''d guess you need to search between 12:01 am and 11:59 pm on the day.

这篇关于vb 6.0中的日期过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！