I have a date field on a document with this date\time:
OD_Date: 04/01/2007 12:00:00 AM (CDT)
When I use this @Month( OD_Date ), I get the value of “3”. I figure that this is probably a problem with the DST change. What can I do to get the correct value for @Month?
Subject: @Month giving incorrect result
I have a slight ammendment to this question. I have found that in a action with @Month the value is correct. The @Month only gives incorrect results in a view column.
Here is my view column formula: @Month( OD_Date ) ← this yields “3”
Here is the action formula: @Prompt([OK] ; “Month Value” ; @Text( @Month( OD_Date ) ) ) ← this yields “4”
Subject: RE: @Month giving incorrect result
I added a date column to the view and the problem went away. I deleted the column and the problem stayed away. I am both perplexed and satisfied… befuddled and ammused.