"Date" question

Hi there,

This might sound really basic … but, I have about 5 fields which is currently using the date picker (basically used for one week). Is there a way to display the week automatically? I have the first field using @today and the 2nd field using @tomorrow, but the 3 other fields, im having a hard time trying to display the day after tomorrow etc … any assistance is greatly appreciated.

Thanks.

Subject: “Date” question.

How about Using @Adjust (@Today;0;0;2;0;0;0), @Adjust (@Today;0;0;3;0;0;0), @Adjust (@Today;0;0;4;0;0;0)?

Good luck.

Subject: RE: “Date” question.

Thanks Hu,

That works! :slight_smile: Greatly appreciated.

Subject: RE: “Date” question.

Another question:

I have a field that the user selects from a datepicker called(From field)

The 5 other fields will have to automatically be calculated by the From field. so the first field uses “FROM”, how can you calculate the next date in the 2nd field? 3rd field etc.

Subject: RE: “Date” question.

I think you’d have to put code in the OnChange or Exiting event of the first field to set the values in the other fields. Or, if the user doesn’t necessarily have to see the values, set them in the QuerySave.

Regards,

Don