Member Avatar for haibec

I have DB Oracle table User include : ID,USERID,MONEY,TIME . I was select a record (The time : 4/11/2009 5:52:55 PM ) select time from user where user ='John' and money>300 . Now i have value : time = rscon("time")

Now i want calculate number day from now to the time = rscon("time").

Plase help me

  • 2 Contributors
  • 1 Reply
  • 70 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by TomBCullen
Member Avatar for TomBCullen

Hi Haibec,

Here is some information to calculate your time frames for you:

Setting Description
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week of year
h Hour
n Minute
s Second

i.e.

DateAdd("d",1,Now)

I hope this helps.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.