Date calculations 6 months due in current month

[Guest]

Hello,

I have setup a form that has a 'date start' and I have created a report to
calculate 6 months in advance from the 'date start' using the following:
=DateAdd('m',6,[DateStart]). My report is works fine I just need to know how
would you do the calculation and return the results just for the current
month. For instance all 6 months due for this month which is January. I
know this has to be very simple. Please help. Thanks in advance

 

[Guest]

Hi blink,

Have two fields, Date Start and Date End and use both fields in your query
instead of Date Start plus 6 months. This way you can run monthly, weely,
daily, quarterly, yearly, whatever you want.

Hope this helps.

Damian.

 

[Guest]

Thanks Damian,

What calculation would be used in the query to achieve this?

Hi blink,

Have two fields, Date Start and Date End and use both fields in your query
instead of Date Start plus 6 months. This way you can run monthly, weely,
daily, quarterly, yearly, whatever you want.

Hope this helps.

Damian.

Hello,

I have setup a form that has a 'date start' and I have created a report to
calculate 6 months in advance from the 'date start' using the following:
=DateAdd('m',6,[DateStart]). My report is works fine I just need to know how
would you do the calculation and return the results just for the current
month. For instance all 6 months due for this month which is January. I
know this has to be very simple. Please help. Thanks in advance