Change date format included right function

[Anonymous]

Hello,

I have one field named PROFILE. That field returns the following data:

000673/2012.04.01.  The first characters are staffnumbers en the others are date of making the staffnumbers

I don't want to use the staffnumbers

How can i change only the 2012.04.01 to a date that i used in my application D-M-YYYY

Thank you

[rohit214]

hello.

try this

=right(000673/2012.04.01. ,11) as date

and front end date(2012.04.01,'dd-mm-yyyy')

or chane formate in your script SET DateFormat='DD-MM-YYYY';

thanks&regards

rohit

[Jason_Michaelides · Accepted solution]

Hi,

Try:

Date(Date#(SubField(PROFILE,'/',2),'YYYY.MM.DD'),'D-M-YYYY') AS Date

Hope this helps,

Jason