I have a column in a view that I want to display the date, based on the user’s local time zone. So, the column is a Date column, with “Adjust to local time zone” selected. This works great, however, I only want to show the DATE, not the time. So, if I try to do @Date(Datefield), then it shows me the date based on the originating timezone, not MY time zone. For example if the document was created at 6/5/2008 11am CST, it will display 6/6/2008 12am for Hong Kong. But, if I only want to show the DATE (remove the time) using @Date(Datefield), it shows 6/5/2008 instead of 6/6/2008!!! How can I get JUST the date of the date field in the local time zone??
Brittany
Subject: TimeZone/Date problem in view
What happens when your try this for the column?
@TimeToTextInZone( YourField ; @GetCurrentTimeZone ; “D0” )
Subject: RE: TimeZone/Date problem in view
Unfortunately @GetCurrentTimeZone gets the server’s time zone, not the user’s.
Subject: RE: TimeZone/Date problem in view
That might work in a Private view, but in a shared view, it would be using the time zone of the Server, not the user.
Subject: TimeZone/Date problem in view
You can’t remove the time and still have a time-zone, so @Date will simply not work.
About the only idea I have would be for show the time in the column, but shrink the column width so that only the date actually shows.
Subject: RE: TimeZone/Date problem in view
Why not use the formatting tab for the column to display the date only?
Subject: RE: TimeZone/Date problem in view
That was my first idea as well, but un-checking the Display Time option removes the ability to select Display in local time zone.
Subject: RE: TimeZone/Date problem in view
This column is a categorized column, so that won’t work. Any other ideas?! I have exhausted all mine…
Brittany
Subject: RE: TimeZone/Date problem in view
Well now you may have an additional problem. If this is a Shared view, the categorization is being done on the Server, and so you simply cannot have the view categorized differently for people in different time-zones.
You may be forced to have a view per time-zone that needs to be supported, or use Private views that would be computed on each user’s client.
Subject: RE: TimeZone/Date problem in view
Actually, that is not true. The view is on the web, and when you select that “Adjust to local time zone”, it defaults to the time zone your user has in the DomTimeZonePrfM cookie that we have our user’s set. (It’s the cookie that Domino uses in $Preferences.nsf). So, the good news is that I can get the date to show up in the proper time zone on a per user basis, but it has to be the full date and time, which I don’t want. I just want the date… I even tried manipulating it (@Right), but it still uses the date from the original time zone. <>
Brittany
Subject: RE: TimeZone/Date problem in view
The time zone is attached to the time component – throw that away and there is no time zone to adjust. The only way to retain the info is to re-index the view using the client’s time zone so that the date component you are using as a category can be created from the adjusted time. Multiple views is the only real choice you have.