<div>
Mari,<br />
<br />
Did you try using the Date functions for example, if you have a varibale @X as &quot;21/10/99&quot; you can create a formula @Y as follows:<br />
<br />
Date(Val(Right({@X}, 4)), Val(Mid({@X}, 4, 2)), Val(Left({@X}, 2)))<br />
<br />
I hope this is what you want. Please let me know.<br />
<br />
Ravi<br />
<br />

</div>


Mari,

Did you try using the Date functions for example, if you have a varibale @X as "21/10/99" you can create a formula @Y as follows:

Date(Val(Right({@X}, 4)), Val(Mid({@X}, 4, 2)), Val(Left({@X}, 2)))

I hope this is what you want. Please let me know.

Ravi



<div>
Could you just explain a little further in how this formula works.<br />
<br />
Thanks<br />
<br />
Mari
</div>


Could you just explain a little further in how this formula works.

Thanks

Mari

<div>
Just what i needed, thanks.<br />
<br />
Mari
</div>


<div>
<div class="content wysiwyg-content">
I am trying to do weekly reports using the FullLastWeek function. The problem is Crystal Reports doesn't recognised the date variable because it is in the wrong format, the problem is I can't seem to find what format the date is supposed to be in.<br />
<br />
1. Do you know what the date format is suppsed to be?<br />
<br />
2. If my variable is not in the correct format (which I cannot change now) is there a way in Crystal Reports that I can change the format of the date?<br />
<br />
3. If number 3 above cannot be done, is there a work around to find the ranges between 2 dates (if the only date formats I am using is YYYYMMDD and DD/MM/YYYY), which I can report on.<br />
<br />
Thanks<br />
<br />
Mari
</div>
</div>


I am trying to do weekly reports using the FullLastWeek function. The problem is Crystal Reports doesn't recognised the date variable because it is in the wrong format, the problem is I can't seem to find what format the date is supposed to be in.

1. Do you know what the date format is suppsed to be?

2. If my variable is not in the correct format (which I cannot change now) is there a way in Crystal Reports that I can change the format of the date?

3. If number 3 above cannot be done, is there a work around to find the ranges between 2 dates (if the only date formats I am using is YYYYMMDD and DD/MM/YYYY), which I can report on.

Thanks

Mari

Crystal Reports 7

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.