Display text as date

[Snoopy]

Hey guys
I use this formula =">="&DATEVALUE(Files!D3)+TIMEVALUE(Files!D3) to
display and use as filteroption.
(Dont ask why I have to do this exercise....)
However the formula works all right but the display appears as
decimalnumber in this text expression:

Actual displayed: >=40170,6145833333
Wanted displayed: >=23.12.2009 14:45:00

I KNOW that there is some way to transform the expression displayed,
but have not found anything useful on the web - so far.
Are there anybody called to give me a hand on this one?

Best regards Snoopy
(Wish you a Happy New Year as well)

 

[Dave Peterson]

I'm not sure if this will work with your filter, but you can change the display:

=">="&text(DATEVALUE(Files!D3)+TIMEVALUE(Files!D3),"dd.mm.yyyy hh:mm:ss")

 

[Snoopy]

I'm not sure if this will work with your filter, but you can change the display:

=">="&text(DATEVALUE(Files!D3)+TIMEVALUE(Files!D3),"dd.mm.yyyy  hh:mm:ss")









--

Dave Peterson– Skjul sitert tekst –

– Vis sitert tekst –

Thanks Dave
I'll dive into this - there is some translation trouble; english vs
norwegian, to by-pass

Best Regards
Snoopy

 

[Harald Staff]

I'll dive into this - there is some translation trouble; english vs
norwegian, to by-pass

TEKST, DATOVERDI, TIDSVERDI.
Hent KeepITcools formeloversetter her, den er uerstattelig:
http://members.chello.nl/jvolk/keepitcool/index.html

HTH. Beste hilsen Harald

 

[Dave Peterson]

Tack så mycket.

(translate.google.com <vbg>)

TEKST, DATOVERDI, TIDSVERDI.
Hent KeepITcools formeloversetter her, den er uerstattelig:
http://members.chello.nl/jvolk/keepitcool/index.html

HTH. Beste hilsen Harald