Date to Decimal Type Conversion

gdkve9
gdkve9 Member Posts: 161
edited 2008-04-10 in NAV/Navision Classic Client
dear frens..

Hope u all doing well. Just having a problem with type conversion. Let me tell you guys this is a bit different from the posts that we have in this forum on "evaluate" as i have searched it hard.Can I have an optimal solution on this one frens. Here it goes..

suppose,

VarDate := 01/02/1996;

How can i evaluate this to decimal ?? I have done this but not able to arrive at....

EVALUATE(VarDec,FORMAT(VarDate));

I have to do this because I have to print the date value in to words and this will happen only if i can convert date to decimal (As the FormatToValue function in report Check only allows decimal as the parameter)..

Let me expect the solution as simple as possible as mibuso group has great experts in Navision CAL

regards in advance to u all guys
Dilip
Falling down is not a defeat..defeat is when you refuse to get up.

Comments

  • Belias
    Belias Member Posts: 2,998
    Can you post your FormatToValue function?
    ...i wonder how does it translate an eventual 1021996 into words...also it would explain better what you want... :-k
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • gdkve9
    gdkve9 Member Posts: 161
    Belias wrote:
    Can you post your FormatToValue function

    That is available in Base World wide version of Nav with report id 1401 my dear fren..

    I am unable to put the code here because its again linked with another functions in the report.

    If you cud suggest me it wud be grateful...Thanq
    Dilip
    Falling down is not a defeat..defeat is when you refuse to get up.
  • Xypher
    Xypher Member Posts: 297
    You want a literal translation of Date to Decimal?

    Try this...
    EVALUATE(VarDec,FORMAT(VarDate,0,'<Month,2><Day,2><Year4>'));
  • kriki
    kriki Member, Moderator Posts: 9,121
    check also this: http://www.mibuso.com/forum/viewtopic.php?t=24973
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories