I'm guessing you don't have Version 7 - but if you do the JulianToDate function should do the trick.
If you don't have V7 the information in the posts [url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=000010#000000"]here[/url] may be helpful.
How do I convert a julian date from a report to a standard date(ie. 19 Nov 04) in monarch. /b[/quote]
[size="1"][ May 18, 2006, 04:03 PM: Message edited by: Todd Niemi ][/size]
I do have version 7 but I can't get it to do what I want! (I'm so confused!)
When I go to the filter definition, I put in the expression box - JulianToDate(04207) and I get a box that pops up saying "operand type". I've also put in there date=JulianToDate(04207), but that doesn't work either.