Calendar Date problem

[jeevays7]

Hi All,

I have reloaded the document and pasted in server. while accessing the document in browser the Date is displaying as "30-Dec-1899".

It is happening frequently and i don't know the reason.

Can someone please help me to resolve this?

PFA.,

[olivierrobin]

hello

it is because your field is either empty or null, so it shows the lowest available date

[jeevays7]

Hi Oliver,

here i'm using a variable to show the date.

[jeevays7]

if i am passing a null value, it is showing null only in the calendar. i tried in a sample application.

[olivierrobin]

and what's the content of that variable

put in in a text box to see it (I would say space)

[rafatashiro]

Use the variable "To" like this :

Max(Not null(Data))

[olivierrobin]

I tried and i see 30-dec-1899 when the variable contains 0

[jeevays7]

The content of the variable is Max({1}Date) only.

[jeevays7]

could you please send me a sample application with this case?

[olivierrobin]

the syntax looks like a set analysis

is is what you see in text box ? or the formula you use ?

the variable should contains a valid date if you want to see it in your calendar