|
|
||||||
|
#1
04-02-08, 05:05 PM
|
|
|
|
|
Hi,
Is it possible to display dates as yesterday, today or tomorrow instead of numeric dates in a list view? Thanks. |
|
|
|
#2
04-02-08, 07:49 PM
|
|
|
|
|
You have to use calculated fields.
Check this link: http://sharepointroad.wordpress.com/...e-with-a-text/ |
|
#3
04-02-08, 08:50 PM
|
|
|
|
|
On 2 avr, 20:49, "Amir Mehrani" <amirmehr> wrote:
> You have to use calculated fields. > Check this link:[..]... > > -- > Amir Mehranihttp://sharepointroad.wordpress.com > Thanks but I don't think this will answer my problem since the TODAY system variable containing today's date and time cannot be used in calculated fields in Sharepoint lists. How can you compare a date to today's date in a formula if today's date cannot be used in a formula? (Today's date can only be used in filters in Sharepoint) |
|
#4
04-03-08, 02:18 PM
|
|
|
|
|
Create a single line of text field name it "Today" replace fields in formula
with "today" and after completion delete Today field you created first. By this way you can compare your date with today's date. This is useful in case you want to mention "x Days Old" for an item. |
|
#5
04-03-08, 09:09 PM
|
|
|
|
|
On 3 avr, 15:18, "Amir Mehrani" <amirmehr> wrote:
> Create a single line of text field name it "Today" replace fields in formula > with "today" and after completion delete Today field you created first. > By this way you can compare your date with today's date. This is useful in > case you want to mention "x Days Old" for an item. This does not work, the today field is never updated with today's date. |
|
#6
04-03-08, 09:24 PM
|
|
|
|
|
Ok. I donno how you've created and what you exactly did. But this is an
examined way. You have to create a single line of text field with "TODAY" name and after creating calculated field and applying formula you have to delete "TODAY" field. It does work. |
|
#7
04-04-08, 05:26 PM
|
|
|
|
|
> > On 3 avr, 15:18, "Amir Mehrani" <amirmehr> wrote:
> >> Create a single line of text field name it "Today" replace fields in > >> formula > >> with "today" and after completion delete Today field you created first. > >> By this way you can compare your date with today's date. This is useful > >> in > >> case you want to mention "x Days Old" for an item. > > > This does not work, the today field is never updated with today's > > date. It does show today's date, but only today... Come back tomorow and your today field will show yesterday's date, which is not the goal I was after. |
|
#8
04-04-08, 09:34 PM
|
|
|
|
|
well, I think I didn't get what you need...
Could you exactly describe what's your goal? |
|
#9
04-05-08, 06:11 PM
|
|
|
|
|
On 4 avr, 22:34, "Amir Mehrani" <amirmehr> wrote:
> well, I think I didn't get what you need... > Could you exactly describe what's your goal? > I want to display dates in a Sharepoint list either as a numerical date, let's say for example "5/4/2008" when that date is not today, and as the word "today" when that date is today. |
|
#10
04-06-08, 11:32 AM
|
|
|
|
|
Ok, I got it. There's one problem for this, We have to hold a text value and
a date value in same field. It means two diffrent data type in one field. holding a date value in a text field will convert date to date serial number. For example serial number for 6/4/2008 will be 39603. So we can't hold a text value and a date value in just one field. By the way, there may be another ways, which I have no idea about them. |
|
#11
04-06-08, 09:35 PM
|
|
|
|
|
On 6 avr, 12:32, "Amir Mehrani" <amirmehr> wrote:
> Ok, I got it. There's one problem for this, We have to hold a text value and > a date value in same field. It means two diffrent data type in one field. > holding a date value in a text field will convert date to date serial > number. For example serial number for 6/4/2008 will be 39603. So we can't > hold a text value and a date value in just one field. > By the way, there may be another ways, which I have no idea about them. > Actualy, the purpose is not to hold a date value in a field, but to display (and not to store) that date from a field value. It would be more a calculated column I was thinking of, but it does not seem possible in Sharepoint, contrary to almost every other piece of software I know, to know what is today's date and time. There is a variable in Sharepoint called TODAY, but weird enough, it cannot be used in calculated fields, which makes it almost useless, I do not know the reason, but what I was after if a way to overcome this limitation. |
|
#12
04-08-08, 09:22 AM
|
|
|
|
|
I wish I could help, but have no idea. Just one way that I have not tested,
but may be creating a custom field definition solve this limitation. |
|
|
| Similar Threads | |
| Getting Dates - today, yesterday help Our order dates field looks like this: 2007-01-01 11:11:43.000 If I just wanted to do a Select on orders today or between a date range, is there a simple way? Instead of... |
|
| shortcut key for yesterday, today and tomorrow entry Hi and thanks for the help. I am using Access 2003. We consistently use the dates for yesterday, today and tomorrow. I know that I can type Ctrl+; to get the current date. In... |
|
| criteria for dates for yesterday and today Access 2K/Win2K. Field has date/time data type. Data is only date - no time included. Using the criteria: between date()-1 and date() but getting error: Data type... |
|
| Outlook Today Calendar View Should Dispaly as: Today, TOMORROW, F. In the Outloook Today view. When it lists calendar events, it should show them as follows: Today___________ (Today being Wednesday) All day event.... Tomorrow________ ... |
|
| Yesterday I was hanged, Today I was hung and Tomorrow I will be... Yes, I am experiencing the same problem, the debugger hanging all to often, although sometimes it works fine. In the end, I have to use the debugger only when absolutely... |
|
|
All times are GMT. The time now is 01:31 PM. | Privacy Policy
|
yesterday, today, tomorrow user friendly dates, possible?