Report date formatting issue? 1

[ajayg]

I have a report which receives the Date in string format (MM/dd/yyyy).

I want to convert this in (dd/MM/yyyy). How should I do it?

I tried the ToText, DateValue techniques, it does not give me consistent result, per say:
expected Result 12/8/2008 shows up as 8/12/2008 , where as 13/8/2008 and onwards come up correctly.

Help needed urgently.

Thanks in advance.
Cheers,
AG

 

[lbass]

You should be able to use:

totext(date({table.stringdate}),"dd/MM/yyyy")

-LB

 

[Charliy]

If it's a string you have to parse it and put it back together.

MID({table.field},4,2)+"/"+LEFT({table.field},2)+"/"+RIGHT({table.field},4)

 

[lbass]

Not necessarily. In some cases, a string date will convert directly to a date by wrapping it in date(). It works for the format "MM/dd/yyyy".

-LB

 

[ajayg]

Thanks for your Post/responses. It fixed my problem.