formatting dates(copying the first part of a date)

nbangaza

On a report:

I have created a variable StartDate which is datatype Date.

I have another variable vDate which is also a datatype Date.

If a user enters on vDate the date 12/03/10|15/04/10 for example, i want to be able to copy the first part of vDate which is 12/03/10 and do calculations based on the users input...but i dont know how to do this.

Anyone know how i can do this? Thanks

Savatage

if vdate is type date - if the user enters 12/03/10|15/04/10 - you'll probably get an error message saying that's an invalid date.

2nd. if the date entered is always 8 characters. you could copystr the first 8 characters & using evaluate function convert it to a date type.

DenSter

http://dynamicsuser.net/forums/t/31741.aspx