date ranges

[Tiina]

How to get empty spaces if the date ranges are 0

datevar range daterange3 := date(0,0,0) to date(0,0,0);

The system calculates these 0's as -

-4714-12-31.

THank you,

TIina

 

[synapsevampire]

In general people will post their software version and the database/connectivity used if they want tailored answers.

Not sure why you would hardcode 0 dates into a variable, are you just trying to be clever and show us part of your difficulty while using date ranges?

Your formula would cause an error because the result of a formula can't be an array (ranges are arrays).

Try the following:

whileprintingrecords;
datevar range daterange3 := date(0,0,0) to date(0,0,0);
minimum(daterange3)

It should show a blank, but no guarantee as software versions change things, which is why professionals should take the time to state it, and to state how you came up with the value you believe that it's returning.

-k

 

[Tiina]

The version is 8.5.

This is an area that the client has to fill in and since it can be blank, I wanted to be able for them to use 0's in order to keep the formula layout 0,0,0.

It is part of much larger formula.

Thanks again,

Tiina