Get last day of the next three months with Crystal Report -

-

i heading find out formula date last day of next 3 months crystal report. i've tried code below shows message when out of array of month (1-12). please give me advice address problem.

totext(date(year({rptiexsaleinvoicesummary.etd}),month({rptiexsaleinvoicesummary.etd})+4,1)-1, "dd-mmm-yyyy")

it works fine if etd's month less 8. however, might cause problem when more 9, 10 image below.

1

i've found solution. please let me know if have idea solve problem.

if (month({rptiexsaleinvoicesummary.etd})+4) > 12  totext(date(year({rptiexsaleinvoicesummary.etd})+1,month({rptiexsaleinvoicesummary.etd})-8,1)-1, "dd-mmm-yyyy") else totext(date(year({rptiexsaleinvoicesummary.etd}),month({rptiexsaleinvoicesummary.etd})+4,1)-1, "dd-mmm-yyyy")

Comments

Post a Comment

Popular posts from this blog

Upgrade php version of xampp not success -

-
today decided upgrade xampp new php version (5.6.11). have downloaded , configured based on google said. after resetting server, runs successfully. when check xampp's phpinfo, has not been updated. screenshot what have missed? back htdocs files , database. download xampp . uninstall xampp control panel. manually remove xampp folder partition. install back problem solved
Read more

amazon web services - S3 and apache mod_proxy with basic authentication -

-
i'd redirect s3 bucket in ssl basic authentication of files (apk files) apache mod_proxy. ssl , mod_proxy work, basic authentication ignored. <virtualhost *:443> servername resources.mydomain.jp <filesmatch "\.apk$"> order deny,allow setenvif user-agent ".*android.*" allow_ag options followsymlinks allow env=allow_ag deny authtype basic authname "secret zone" authuserfile /etc/httpd/.htpasswd require user xxx_customer </filesmatch> sslengine on sslproxyengine on sslprotocol -all +sslv3 +tlsv1 sslciphersuite all:!adh:rc4+rsa:+high:+medium:-low:-sslv2:-exp sslcertificatefile conf.d/xxx.cer sslcertificatekeyfile conf.d/xxx.key sslcacertificatefile conf.d/xxx.cer proxypass / http://resources.mydomain.jp.s3-website-ap-zone-1.amazonaws.com/ proxypa...
Read more

powershell - This solution contains one or more assemblies targeted for the global assembly cache -

-
Image
i having sharepoint site deployed through sharepoint powershell. wsp build through visual studio 2013. all projects in solution not signed assemblies(project->right click->properties->signing->sign assemblies check box unchecked). taking wsp of solution publishing , deploying sharepoint using sharepoint powershell. when try this, getting following error: when googled solution. many of them suggesting check 'sign assemblies' check box. don't want do, because facing other issues packages install through nugget. sign libraries of solution go properties of project click signing tab , check sign libraries options , create new strong name file or without password , rebuild , deploy.
Read more