|
Your continued generosity and support of FMForums is greatly appreciated. |
merkaba22
master
Posts: 342
Loc: Hollywood, CA
Post Rank (AVG):
FMP: 10
OS: Mac OS X Snow Leopard
Skill: Advance
 Tweet This Post!
|
I am aware that FileMaker can modify dates, for example, fora date a year later:
(date + 365).
However, in the case of a month later:
(date + 30)
does not return the same day a month later.
Is there another way to calculate this requirement?
"We are the ones we have been waiting for!”
"We owe a lot to the Indians (from India), who taught us how to count, without which no worthwhile scientific discovery could have been made." - Albert Einstein.
Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did do ... Explore. Dream. Discover'. Mark Twain
"Someday," Neil Young said, "the digital age will be seen as the Dark Ages of recorded sound."
"Like the Maya, we shall understand that the path to the stars is through the senses."
"Dream big -- because no matter how big that is, it's nothing compared to what you really can do".
"Using the most reliable approach for bending reality to your desires, imagination is always the key first ingredient, then by adding clear intention, expectation and action, results will be realized."
|
|
|
|
raybaudi
ChindoguMaker
Posts: 2678
Loc: Italy Rome
Post Rank (AVG):
FMP: 10 Advanced
OS: Windows XP
Skill: Intermediate
Tweet This Post!
|
In response to merkaba22
If the starting DATE is: 01/30/2010
which must be the ending one ?
Daniele
--------------------------------
I'm sorry for my English |
|
merkaba22
master
Posts: 342
Loc: Hollywood, CA
Post Rank (AVG):
FMP: 10
OS: Mac OS X Snow Leopard
Skill: Advance
Tweet This Post!
|
In response to raybaudi
Thanks Daniele:
Good point, but if there is a calc where the starting DATE is:
01/27/2010
the result required would be:
02/27/2010
"We are the ones we have been waiting for!”
"We owe a lot to the Indians (from India), who taught us how to count, without which no worthwhile scientific discovery could have been made." - Albert Einstein.
Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did do ... Explore. Dream. Discover'. Mark Twain
"Someday," Neil Young said, "the digital age will be seen as the Dark Ages of recorded sound."
"Like the Maya, we shall understand that the path to the stars is through the senses."
"Dream big -- because no matter how big that is, it's nothing compared to what you really can do".
"Using the most reliable approach for bending reality to your desires, imagination is always the key first ingredient, then by adding clear intention, expectation and action, results will be realized."
|
|
comment
consultant
Posts: 15253
Post Rank (AVG):
FMP: 7 Advanced
OS: Mac OS X Panther
Tweet This Post!
|
In response to merkaba22
And if starting date is 01/31/2010?
|
 Lee Smith
*$ time
Posts: 8286
Loc: Woodland - Sacramento, CA...
Post Rank (AVG):
FMP: 10 Advanced
OS: Mac OS X Snow Leopard
Member: TechNet
Skill: Advance
Tweet This Post!
|
In response to merkaba22
Do you mean this?
Date ( Month ( AnyDate ) + 1 ; Day ( AnyDate ) ; Year ( AnyDate ) )
Lee
|
merkaba22
master
Posts: 342
Loc: Hollywood, CA
Post Rank (AVG):
FMP: 10
OS: Mac OS X Snow Leopard
Skill: Advance
Tweet This Post!
|
In response to Lee Smith
Thanks Lee -- you nailed it!
"We are the ones we have been waiting for!”
"We owe a lot to the Indians (from India), who taught us how to count, without which no worthwhile scientific discovery could have been made." - Albert Einstein.
Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did do ... Explore. Dream. Discover'. Mark Twain
"Someday," Neil Young said, "the digital age will be seen as the Dark Ages of recorded sound."
"Like the Maya, we shall understand that the path to the stars is through the senses."
"Dream big -- because no matter how big that is, it's nothing compared to what you really can do".
"Using the most reliable approach for bending reality to your desires, imagination is always the key first ingredient, then by adding clear intention, expectation and action, results will be realized."
|
|
LaRetta
Developer
Posts: 7467
Post Rank (AVG):
FMP: 11 Advanced
OS: Cross Platform
Member: TechNet, FBA
 FMPug
Tweet This Post!
|
In response to merkaba22
However, in the case of a month later: (date + 30)
does not return the same day a month later. Is there another way to calculate this requirement?
You are missing the point by Daniele (although his example didn't show it) and Michael (Comment):
If the start is 1/31/2010, one month later would be 2/31/2010 which FM would translate to 3/3/2010 (or 3/2 if a leap year). You must define the rules on how the calculation should handle the difference when the number of days in the result month is shorter than the number of days in the beginning date. Do you want the last day of the SAME month or do you want it to run into the next month by (up to) 3 days?
Edited by LaRetta on 03-09-10 03:32 PM. Reason for edit: No reason given.
|
merkaba22
master
Posts: 342
Loc: Hollywood, CA
Post Rank (AVG):
FMP: 10
OS: Mac OS X Snow Leopard
Skill: Advance
Tweet This Post!
|
In response to LaRetta
Thanks Loretta -- but I did get it, that; why I changed the day ...
Nonetheless, you did provide me he answer to my next question and I thank you for that!
"We are the ones we have been waiting for!”
"We owe a lot to the Indians (from India), who taught us how to count, without which no worthwhile scientific discovery could have been made." - Albert Einstein.
Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did do ... Explore. Dream. Discover'. Mark Twain
"Someday," Neil Young said, "the digital age will be seen as the Dark Ages of recorded sound."
"Like the Maya, we shall understand that the path to the stars is through the senses."
"Dream big -- because no matter how big that is, it's nothing compared to what you really can do".
"Using the most reliable approach for bending reality to your desires, imagination is always the key first ingredient, then by adding clear intention, expectation and action, results will be realized."
|
|
merkaba22
master
Posts: 342
Loc: Hollywood, CA
Post Rank (AVG):
FMP: 10
OS: Mac OS X Snow Leopard
Skill: Advance
Tweet This Post!
|
In response to LaRetta
The requirements for the calc is that if the start date is 1/31/2010,one month later should be 2/28/2010, or 2/29/2010 if it's a leap year.
"We are the ones we have been waiting for!”
"We owe a lot to the Indians (from India), who taught us how to count, without which no worthwhile scientific discovery could have been made." - Albert Einstein.
Twenty years from now you will be more disappointed by the things you didn't do than by the ones you did do ... Explore. Dream. Discover'. Mark Twain
"Someday," Neil Young said, "the digital age will be seen as the Dark Ages of recorded sound."
"Like the Maya, we shall understand that the path to the stars is through the senses."
"Dream big -- because no matter how big that is, it's nothing compared to what you really can do".
"Using the most reliable approach for bending reality to your desires, imagination is always the key first ingredient, then by adding clear intention, expectation and action, results will be realized."
|
|
comment
consultant
Posts: 15253
Post Rank (AVG):
FMP: 7 Advanced
OS: Mac OS X Panther
Tweet This Post!
|
In response to merkaba22
See:
http://fmforums.com/forum/showpost.php?post/217855/
|
|
Your continued generosity and support of FMForums is greatly appreciated. |
Vaughan
Mostly Harmless
Posts: 8179
Loc: Sydney, Australia
Post Rank (AVG):
FMP: 9 Advanced
OS: Mac OS X Leopard
Member: TechNet
Skill: Advanced
Certified:
    
Tweet This Post!
|
In response to merkaba22
Change the requirement to specify an explicit number of days.
There is a reason why some warranties are specified as 30 days or 60 days. It avoids all confusion and ambiguity.
| Vaughan Bromfield
Sydney, Australia
Please post questions to the Forum, not directly to me. Back-up your files before making changes!
Whenever I hear the term "popular culture" I reach for my Iridium Q-36 Space Modulator. |
|
|
|
