how to convert number to date ...

[rb2005]

hi,

I have to compare to date field, one is numeric and one is date. How do I change numeric field to date or date to numeric. I have used totext but not working properly.
I am using CR 10.

RB

 

[lupins46]

Can you show here a sample of pairs of values that are supposed to match?

 

[rb2005]

date1 is date andtime 5/31/2005
date2 is number 20050531

I want to write a formula like

if date1<> date2 then date2

 

[lupins46]

if date1<>dateserial(left(date2,2)mid(date2,3,2),right(date2,2) then
date2
else
????//some other date

This assumes that the time part of date1 is always zero.

 

[dgillz]

Numbertodate() works perfectly for this application. I believe it is a UFL andneeds to be downloaded from the BO website however.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz