• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1132
  • Last Modified:

lotus formula date question

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


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.
3 Solutions
Question, if the startdate is @Created, or the date/year it was created, won't the year always be correct?
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 !
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 )

startdate := @Date(@Year(@Now); 1; 3);
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now