filemaker - Custom Function - Calculate date of first date of next quarter -


i trying create custom function of given date in filemaker, determine if week of fiscal year number within first week of quarter else calculate first date next quarter. our fiscal year starts on july 1

so defined requirements our fy starts on july 1 , qtrs on week # 1, 14, 27, 40 our weeks go 1-52 , week starts on tuesday (defined day 3). if fy starts on monday first week mon-tues (therefore shortweek) week 2 full 7 day week.

example---> if have date 09/09/2011 week 11 in q1, therefore since not first week of quarter following date next qtr wk 14 first date of 9/27/2011. evaluation needs determine whether given date within first week of qtr (weeks 1, 14, 27, 40) or provide first week of next qtr.

also here initial cf working brian dunnings site.

https://www.briandunning.com/cf/147

i know developed in filemaker there maybe developed in language may apply...

thanks in advance

try starting point:

let ( [  startfy = date ( 7 ; 1 ; year ( datefield ) - ( month ( datefield ) < 7 ) ) ; firsttuesday = startfy - mod ( startfy - 2 ; 7 ) ;  fiscalweek = div ( datefield - firsttuesday ; 7 ) ;  //numbering starts @ 0 targetweek = 13 * ceiling ( fiscalweek / 13 )  ] ; firsttuesday  + 7 * targetweek  )

note result always tuesday; may want adjust boundary cases of fiscal year start , end. way works now, you'll result of july 30, 2015 both june 15, 2015 , july 6, 2015.


-

Comments

Post a Comment

Popular posts from this blog

c# - Binding a comma separated list to a List<int> in asp.net web api -

the default binder in web api expecst http://url.com/webapi/report/?pageids=3243&pageids=2365 to bind public ihttpactionresult report(list<int> pageids){ // exciting webapi code} i wish bind http://url.com/webapi/report/?pageids=3243,2365 as running out of space in url get . i have created class public class commaseparatedmodelbinder : system.web.http.modelbinding.imodelbinder { public bool bindmodel(httpactioncontext actioncontext, modelbindingcontext bindingcontext) { //binding in here } } and registered in webapiconfig.cs var provider = new simplemodelbinderprovider( typeof(list<int>), new commaseparatedmodelbinder()); config.services.insert(typeof(modelbinderprovider), 0, provider); i have altered method signature use model binder so public ihttpactionresult report( [modelbinder] list<int> pageids){ // exciting webapi code} however break point in binder not being
Read more

Delphi 7 and decode UTF-8 base64 -

in delphi 7, have widestring encoded base64(that received web service widestring result) : pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg== when decoded it, result not utf-8: <?xml version="1.0"?> <string>طھط³طھ</string> but when decoded base64decode.org, result true : <?xml version="1.0"?> <string>تست</string> i have use encddecd unit decodestring function. the problem have using decodestring . function, in delphi 7, treats decoded binary data being ansi encoded. , problem text utf-8 encoded. to continue encddecd unit have couple of options. can switch decodestream . instance, code produce utf-8 encoded text file data: {$apptype console} uses classes, encddecd; const data = 'pd94bwwgdmvyc2lvbj0ims4wij8+dqo8c3ryaw5nptiq2lpyqjwvc3ryaw5npg=='; var input: tstringstream; output: tfilestream; begin input := tstringstream.create(data); try output := tfilestream.
Read more

html - Is there any way to exclude a single element from the style? (Bootstrap) -

so, have img logo, overlaid on div styled background-image: url("...") , , both elements inside 2 div classes .to-color , .to-overlay respectively, black transparent overlay. is there way exclude logo style given these 2 classes? here's jsfiddle example: link html , css example: - html - <div class="to-color"> <div class="to-overlay"> <div class="respo"> <div class="row"> <div class="col-xs-4 col-xs-offset-4 text-center"> <img src="http://ansonalex.com/wp-content/uploads/2011/06/google-logo-768x260.png" alt="..." class="img-responsive"> </div> </div> </div> </div> </div> - css - .to-color { background-color: #000; } .to-overlay { opacity : 0.5; } .respo { background-image: url("https://source.unsplash.com/category/objects/1600x900"); background-position: center center;
Read more