peterfarouk
17th July 2003, 12:57
I am using the function
num.to.date$(date.num() - SpecificNoOf Days,0)
to return the needed date

The problem is it is returned as a String but i need it as a date(tcdate) so which function I can use

note:I tried this
domain tcdate RequirDate
RequirDate=lval(num.to.date$(date.num() - SpecificNoOf Days,0))
but it is getting me wrong date

if today is 17/07/2003 and variable SpecificNoOf Days=17
so the RequiredDate should equal 30/06/03 but instead it is equal
to Zero ???!!!!

thankx for helping me.

zardoz
17th July 2003, 13:25
Sometimes things are simpler as we imagine ;)

just use
newdate = date.num() - SpecificNoOfDays

peterfarouk
17th July 2003, 13:50
Ya man you are right :D