Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Eomonth Post Reply Post New Topic
Author Message
kv41282
Newbie
Newbie


Joined: 06 Mar 2010
Online Status: Offline
Posts: 7
Quote kv41282 Replybullet Topic: Eomonth
    Posted: 28 Apr 2018 at 12:11pm
I use CR 13,
Is there an alternative function for the EOMonth -function ?

I cant find EOMonth in my program and i have to calculate de last dat of the Month after i have count also 30 days after a date in my database.

For example: DB-date = 24-04-2018
Dateadd (d,30, {DB-date}) gives me 24-05-2018.
And then i have to calculate to 31-05-2018 (last day of the month )or 01-06-2018 (First day of the next month).


Edited by kv41282 - 29 Apr 2018 at 7:28am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Apr 2018 at 5:34am
for current month here is one option:

dateserial(year(currentdate),month(currentdate)+1,1-1)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.