End Date Alert

[#1]

Hi,

I would like to display the number of days left and alert symbol when Warranty End Date is 2 days before Today's Date.

I tried by giving Today() - Warranty End Date but its giving some random value as 45545..Kindly Help !!!

[Anonymous]

Hi

So it doesnt show this "random value" like you've just mentioned, try entering the function Date. It should be something like:

Date(Today() - Warranty End Date)

[Gysbert_Wassenaar]

Dates are numbers too. Try this for example in a textbox: =Today(). You'll see today's date in your documents default date format. Next try =num(Today()). You should now see the numeric value of today's date, i.e. 42478.

If you get 45545 if you subtract your Warranty End Date value from Today() then you have a very funny value in your Warranty End Date field. You might want to check if that field really contains dates or only text values that only look like dates. Perhaps you should use the date#() function in the load script to turn text values into real date vales.