473,507 Members | 2,374 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Formula to caluclate date automatically

Hi,

Does anyone know if it's possible to have a field automatically update
itself with the contents of another field in MySQL?

I have 2 fields DueDate and DaysOverdue. DueDate is a date field and
DaysOverdue is todays date minus DueDate. I can do this is using a sql
statement. However, can I make it automatic so that as soon as DueDate
changes then the value of DaysOverdue changes as well.

Thank you
Maziar A.
Jul 19 '05 #1
0 1059

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1445
by: Maziar Aflatoun | last post by:
Hi, Does anyone know if it's possible to have a field automatically update itself with the contents of another field in MySQL? I have 2 fields DueDate and DaysOverdue. DueDate is a date field...
2
3140
by: celsius | last post by:
Hi folks, Al Bowers wrote this program on comp.lang.c Date: 2001-07-09 13:41:58 PST #include <stdio.h> int isleap (unsigned yr); static unsigned months_to_days (unsigned month); static long...
2
7039
by: Łukasz W. | last post by:
Hello everybody ! How is it in Selection Formula to work with Date type, for example to deduct 7 days, week, month, year from CurrentDate. I'm trying to use such a stetement (CurrentDate - Date...
5
12177
by: nedian | last post by:
Hello I am student and trying to learn access.I am having problem in making a program can any one help me? i wanted to make 2 tables in access and then create a link.First i am telling u what...
9
3037
by: deaconj999 | last post by:
Hi All, I am using this unbound to add the frequency to a date entered =IIf(="HIGH - annual",+365,IIf(="MED - 3 yearly",+1095,IIf(="LOW - 5 yearly",+1825,IIf(="N/ A",Date())))) but would...
1
2778
by: amanda27 | last post by:
Right now I have a formula in the criteria of a query that tells it to pull data (from a datetime stamp field) with the date that is less than or equal to this Friday's date but I need it to not pull...
12
2872
Presto731
by: Presto731 | last post by:
I'm having a formulating dilemma that I hope anyone can help with. I need to do some reporting for a list of people so I can know there anniversary dates for charging them. However the way it works...
2
1629
by: =?Utf-8?B?QWxhbg==?= | last post by:
I have a InfoPath form that I need to use an event handler to perform a calculation. The calculation is derived from a excel formula that calculates the second tuesday of the month when the user...
1
3639
by: =?Utf-8?B?bGF3ODc4Nw==?= | last post by:
i am looking for some MS Excel formula or MS Visal Basic Marco for converting Date to Lunar Date. tks
2
2907
by: welshkaiboy | last post by:
Due to the size of the data I have to manipulate I need to apply a excel formula in access which determines date of manufacture from a serial number 716001 so I use...
0
7319
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7376
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7031
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7485
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5623
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1542
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
760
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.