Date to Decimal Type Conversion

gdkve9

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

Belias

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

gdkve9

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

Xypher

You want a literal translation of Date to Decimal?

Try this...

EVALUATE(VarDec,FORMAT(VarDate,0,'<Month,2><Day,2><Year4>'));

kriki

check also this: http://www.mibuso.com/forum/viewtopic.php?t=24973