| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
I need the fiscal year start and fiscal year end in order to find out what
Fiscal Year this case closed in. So far I have this calculation to get the Fiscal Year Start Date where I am trying to get the year it closed then add July 1 to that date for the start of the fiscal year. Once I can also get the Fiscal Year Close date then I have to find out if the close date was between those dates? FYBegin  ate( DatePart("yyyy",[Date Close]),yyyy)+DateAdd(m,+7,d,+1)thanks, -- Janis |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Try:
FYBegin: DateSerial(Year([Date Close]) + (Month([Date Close]) < 7), 7, 1) -- HTH Van T. Dinh MVP (Access) "FilemakerPro_Developer" <(E-Mail Removed)> wrote in message news:3FA390C6-E7A7-44CB-9759-(E-Mail Removed)... >I need the fiscal year start and fiscal year end in order to find out what > Fiscal Year > this case closed in. > So far I have this calculation to get the Fiscal Year Start Date where I > am > trying to get the year it closed then add July 1 to that date for the > start > of the fiscal year. Once I can also get the Fiscal Year Close date then > I > have to find out if the close date was between those dates? > FYBegin ate( DatePart("yyyy",[Date Close]),yyyy)+DateAdd(m,+7,d,+1)> thanks, > -- > Janis |
|
|
|
|
|||
|
Guest
Posts: n/a
|
THANk you
-- Janis "Van T. Dinh" wrote: > Try: > > FYBegin: DateSerial(Year([Date Close]) + (Month([Date Close]) < 7), 7, 1) > > -- > HTH > Van T. Dinh > MVP (Access) > > > > "FilemakerPro_Developer" <(E-Mail Removed)> > wrote in message news:3FA390C6-E7A7-44CB-9759-(E-Mail Removed)... > >I need the fiscal year start and fiscal year end in order to find out what > > Fiscal Year > > this case closed in. > > So far I have this calculation to get the Fiscal Year Start Date where I > > am > > trying to get the year it closed then add July 1 to that date for the > > start > > of the fiscal year. Once I can also get the Fiscal Year Close date then > > I > > have to find out if the close date was between those dates? > > FYBegin ate( DatePart("yyyy",[Date Close]),yyyy)+DateAdd(m,+7,d,+1)> > thanks, > > -- > > Janis > > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Caculation | =?Utf-8?B?UmljaGFyZGI=?= | Microsoft Access Queries | 6 | 26th Aug 2007 06:30 AM |
| anybody not use caculation | accessuser via AccessMonster.com | Microsoft Access Forms | 22 | 19th Dec 2006 10:13 PM |
| Caculation on Report | =?Utf-8?B?SnVsaWEgVA==?= | Microsoft Access Reports | 1 | 24th Sep 2004 07:41 AM |
| Per Diem Caculation | Microsoft Excel Worksheet Functions | 4 | 7th Mar 2004 12:38 AM | |
| Auto Caculation | Dave Thomas | Microsoft Excel Misc | 1 | 22nd Jan 2004 08:13 PM |
