| Author |
Message |
Macavity
Groupie
Joined: 24 Sep 2012
Online Status: Offline
Posts: 93
|
  
Topic: lastfullmonth
Posted: 27 Jan 2014 at 5:15am |
|
Hi,
Anyone an idea why
minimum(lastfullmonth) displays as 01/07/2006
maximum(lastfullmonth) displays as 31/07/2006
?
thanks
|
 IP Logged |
|
|
|
lolly54
Groupie
Joined: 25 Sep 2011
Online Status: Offline
Posts: 58
|
Posted: 27 Jan 2014 at 5:38am |
|
when you use lastFullMonth, you don't need to split it into two formulas to get the first day of the month or last day of the month.
I think the problem you have is not related to lastFullMonth, it's on your Crystal Report system date and time.
can you please open a test formula as follow:
{@Test Current Time}
CurrentDateTime
What do you get? Is it today's day or some day in 2006 again?
|
| IP Logged |
|
Macavity
Groupie
Joined: 24 Sep 2012
Online Status: Offline
Posts: 93
|
Posted: 27 Jan 2014 at 5:45am |
|
The two formula's are for display purposes
I will test currentdatetime tomorrow.
However, other reports on the same server with the same test display 1/12/2013 to 31/12/2013
just can't figure it out
|
| IP Logged |
|
Macavity
Groupie
Joined: 24 Sep 2012
Online Status: Offline
Posts: 93
|
Posted: 28 Jan 2014 at 3:10am |
|
Unbelievable, currentdatetime displays as 8/8/2006, the servers date is correct, where does Crystal get that ?
|
| IP Logged |
|
Macavity
Groupie
Joined: 24 Sep 2012
Online Status: Offline
Posts: 93
|
Posted: 28 Jan 2014 at 3:17am |
|
I tried to change from system short format to another format, that doesn't help
|
| IP Logged |
|
lolly54
Groupie
Joined: 25 Sep 2011
Online Status: Offline
Posts: 58
|
Posted: 28 Jan 2014 at 4:23am |
|
Then this is definitely not related to lastFullMonth or your other formulas.
It is your system time. Changing the system short format or other format won't help.
Maybe open another post and ask... I'd would love to know why only for this report also. Good luck!
|
| IP Logged |
|
Macavity
Groupie
Joined: 24 Sep 2012
Online Status: Offline
Posts: 93
|
Posted: 28 Jan 2014 at 5:11am |
|
Found the problem !
on the menu under reports there's a set print date and time, that was set to a specific date (in 2006), changed it to 'today's date and time'.
so currentdatetime uses print date
|
| IP Logged |
|
|
|
