Deleting values that are right of a space

HCL Domino Domino Forum
1

Hi,

I have the @modified field that displays the date and time of when a page is last modified.

It displays the following format xx/xx/xx HH:MM but I want a formula that will remove the time and just display the date.

Maybe so it just displays the first 8 chars?

Any one know how i can do this

Thanks

K

2

Subject: RE: deleting values that are right of a space

@Date(@Modified)

Never use string functions to pick apart the text version of a date; not everybody’s computer formats dates the same way.

Never store a date in a text field if you can avoid it.

3

Subject: deleting values that are right of a space

It sounds like this is a text field, since a date/time field would hide the time by default. As Andre posted, you should avoid storing date/times in text fields if at all possible.

4

Subject: deleting values that are right of a space

First of all… only displaying the date of a date/time is a standard option withing columns and fields … check the properties. to do it manually:

lets say theDate is the date/time field

@Text(@Month(theDate)) + “/” + @Text(@Day(theDate)) + “/” + @text(@Year(theDate))

you could also try this:

@Left(@Text(theDate);8))

but it depends on your local settings whether it is shows 01/01/2004 or 1/1/2004.