Hi Guys i just saw some forum and tried using the LET Function to figure out this. My Current Record Date is : 15/01/2014 and Function is like this.
[ Day = Left ( Date ; 2 );
Month = Middle ( Date ; 4 ; 2 );
; Month & "/" & Day & "/" & Year )
The Result is 01/15/2014
So i think i got this solved by seeing other forums
Stumbled across with another set of problem. Some Dates ar per old record were mentioned 15/1/2014 instead of 15/01/2014 for which the result all messed up. now looking for some expert advice how to check the condition in above scrip?
Let ( [ DateList = Subsitute ( Date ; "/" ; ¶ ) ;
Day = Getvalue ( DateList ; 1 ) ;
Month = GetValue ( dateList ; 2 );
Year = GetValeu ( DateList ; 3 ) ] ;
Date ( Month ; Day ; Year )