What can I do about this date token error? When I try to apply yyyy/mm/dd format, I get the error 9302 message and the result is the month comes up as zeros.
Question
Question
date token month is wrong, error 9302
Answer
Try MM rather than mm. Lower case mm refers to minutes rather than months.
This article on MSDN, while aimed at developers, has a lot of good information on how to format dates. There's also a good one on numeric formatting.
Interesting... The change from mm to MM worked! But, making the dd capitalized made the day wrong. But, using MM/dd gets the right month and day. Huh. Thanks for your help, Aaron.
Devin, now that I've looked at the articles, I can see why the Capitals or small letters bring back different results. Very helpful, as well! Thanks!
The link that Devin Goble provides isn't the syntax that Laserfiche uses. Workflow and Quick Fields use that syntax to format tokens, but not the Windows desktop client, Web Access, or Snapshot.
http://www.laserfiche.com/support/webhelp/Laserfiche/9.1/en-US/AdminGuide/LFAdmin.htm#Custom_Date_Time_Field_Display.htm describes the date/time field format syntax.
Good to know. I've done most of my formatting in Workflow, and I just used the format strings that I already knew from .NET. Every time I've done formatting in the Client it probably just happened to be something that had overlapping functionality.