Problems with Dates

[celauritz]

I have a field named {VODTRN.VTTDAT} that gives the numberical date (ex: 20060101) for the date. I have converted that date to 1/1/2006 by using this formula:

//true date
WhilePrintingRecords;
NumberVar input := {VODTRN.VTTDAT};
If input < 20000101 then Date (2000, 01, 01) else
Date ( Val (ToText (input, 0 , "") [1 to 4]),
Val (ToText (input, 0 , "") [5 to 6]),
Val (ToText (input, 0 , "") [7 to 8]) )

This works great. Except for the fact that I cannot use my new formula in the select expert. I want to be able to run a report covering the last x amount of days by saying that true date>=currentdate-x however, since I cannot use my formula in the select expert, I have no idea how to do so.

Please help.

Thanks in advance.

 

[BobSuruncle]

If possible, you should write a SQL Expression to convert the number to a Date.
The SQL Expression could then be used in the Record Selection Formula.

If you can't use a SQL Expression, then change your formula to remove the "WhilePrintingRecords" line.

It should then be available in the Record Selection Formula, but filtering will happen locally.

Bob Suruncle

 

[celauritz]

Thanks. Worked great.