Hi All I want to show the number of week like ‘Week 09; Week 10’ in a form . How can I do this with the Format -function (without other calculations) in the SourceExpr of a Textbox? 'Week '+FORMAT(DATE2DWY(Today(),2)) returns ‘Week 9’ bye Andre
Hallo André, please use ‘Week ‘+FORMAT(TODAY,0,’<Filler Character,0><Week,2>’) MfG Josef Metz
Hallo Josef Thank you very much. It works [:)]. After your posting I found this in the helpfile. But there is no information how to use it [:(!]. On other hand I found several threads here on Navision.net regarding the AttributeName. Format := [Standard Format | Filler | 1000Character | Comma | Overflow | Filler Character | Precision] Is it possible to get an explanation for all six options in one posting from somebody? Perhaps in the ‘Tips & Tricks’ - section. I think this would be very helpful for a lot of people here. Thank you in advance. bye Andre
Hallo André, you can find explanations to in Help to FORMAT property. you can call it from FORMAT-Function Help. MfG Josef Metz
Hi Josef
quote:
Originally posted by jm
… you can find explanations to in Help to FORMAT property. …
Am I blind [8D]? In my helpfile (3.01B) I found only the mention of filler character. Here the piece of text again: Format := [Standard Format | Filler | 1000Character | Comma | Overflow | Filler Character | Precision There is no explanation who to use it like e.g how to use the date or decimal format. Now I know how I can use filler character (with your help Thank you again). But what is e.g. with Overflow or Filler? Nice to read about it! But how can I use this?[:(] It is for me a ‘hidden’ feature only for those who know [:(!]! bye Andre
Hallo Andre, Yes you’re right, there not so much help as needed to understand fully. I found a request at Archived German Support by serching for “overflow”, which show most of the parameters: MESSAGE(‘1. %1’,FORMAT(010196D,0,’<Day,2><Filler,~>’)); MESSAGE(‘2. %1’,FORMAT(010196D,0,’<Day,2><Filler Character,~>’)); MESSAGE(‘3. %1’,FORMAT(010196D,0,’<Day,2><Filler Character, >. <Month Text,3> ‘)); MESSAGE(‘4. %1’,FORMAT(010196D,0,’<Standard Format,7>’)); MESSAGE(‘5. %1’,FORMAT(-123456.99,0,’<Integer Thousand,10><Filler Character,~>’)); MESSAGE(‘6. %1’,FORMAT(-123456.99,0,’<Integer Thousand,10><Filler,~>’)); MESSAGE(‘7. %1’,FORMAT(-123456.99,0,’<Integer Thousand,5><Overflow,~>’)); MESSAGE(‘8. %1’,FORMAT(-123456.99,0,’<Standard Format,0><Comma,&>’)); MESSAGE(‘9. %1’,FORMAT(-123456.99,0,’<Sign,1><Integer,10><Filler Character,~>’)); MESSAGE(‘10. %1’,FORMAT(-123456.99,0,’<Sign,1><Integer,10><Filler,~>’)); MESSAGE(‘11. %1’,FORMAT(-123456.99,0,’<Sign,1><Filler,~>’)); MESSAGE(‘12. %1’,FORMAT(+123456.99,0,’<Sign,1><Filler,~>’)); MESSAGE(‘13. %1’,FORMAT(010203.045T,0,’<Standard Format,2>’)); MESSAGE(‘14. %1’,FORMAT(010203.045T,0,’<Hours24,2><Filler Character,0><Minutes,2><Seconds,2><Comma,.>T’)); please try that. I suppose that the help is so miserable, because of incorrect working of the parameters “Comma” and <1000Character>. the request was from 1996/1997, and there were more incorrect working parameters than today in version 3.60 and i think that the help is not changed since 1996/1997 at this point. hope that will help you. MfG Josef Metz
Hi Josef
quote:
Originally posted by jm
… ‘Week ‘+FORMAT(TODAY,0,’<Filler Character,0><Week,2>’) …
I’m just write a little ‘supplement’ for the Navision helpfile. During the tests I found that the following does the job: ‘Week ‘+FORMAT(TODAY,0,’<Week,2>’) Thank you for your hint (it was the basis [:)]). I collect several posts regarding ‘Format’ in one post and will post it in the ‘Tips & Tricks’ - section. bye André