Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

lotus formula date question

Posted on 2007-04-01
3
1,105 Views
Last Modified: 2013-12-18
Hi all,

date question in lotus formula language

On the form,
I have startdate datetime field with the following value = @created
I have a lifecyle number field with a default value of 1
I have enddate datetime field with the following fromula @Adjust(startdate;lifecycle;0;0;0;0;0)

& that's all working fine

Question,

I want to the startdate field to have the year portion as a dynamic portion, this way the dates relating to it will always have the current year in place.

For example,

startdate = [01/03] + @year(@now)
Where the value of the startdate will be 01/03/2007 if the year is 2007 and 01/03/2008 if the year is 2008.
I have tried many combination of @text & @texttotime to get the startdate to work properly but it wouldn't. as well as the enddate always give me an eror for incorrect data type.
Any help is much appreciated.
Varvoura
0
Comment
Question by:varvoura
3 Comments
 
LVL 18

Accepted Solution

by:
marilyng earned 84 total points
ID: 18831732
Question, if the startdate is @Created, or the date/year it was created, won't the year always be correct?
0
 
LVL 63

Assisted Solution

by:SysExpert
SysExpert earned 83 total points
ID: 18832829
I think all that you need to do is use the Format command or change your views/fields to show the year as part of the date.

I hope this helps !
0
 
LVL 22

Assisted Solution

by:Bill-Hanson
Bill-Hanson earned 83 total points
ID: 18836009
I'm not sure what you are trying to accomplish, but the correct way to construct a date is with the @Date function.

@Date( year ; month ; day )
@Date( year ; month ; day ; hour ; minute ; second )
@Date( time-date )

Ex:
startdate := @Date(@Year(@Now); 1; 3);
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question