Format Date

[emuye]

2001/03/05 11:46:00.00

How can i format the above date field to YY/DD/MM where yy means year, dd stands for date and mm stands for month
thanx

 

[lbass]

Try:

totext({table.datetime},"yy/dd/MM")

-LB

 

[emuye]

I tried your method however it says too many arguments have been given to this function.

 

[lbass]

I'm guessing your field is actually a string, so try the following:

totext(dtstodate({table.stringdate}),"yy/dd/MM")

If this doesn't work, please browse your field and report back with its datatype.

-LB

 

[emuye]

Thank you it worked! You guess is right my field is a stirng . again thanx