i have 5 tables with common date coloumn but format is different but i want change date coloumn format same in all tables without making changes in script level ? how? pls help me......

[#1]

i have 5 tables with common date coloumn but format is different but i want change date coloumn format same in all tables without making changes in script level ? how? pls help me......

thanks in advance

[datanibbler]

Hi manoj,

so you want to avoid the tables automatically linking in the DataModel? (That's the only reason I can imagine for not wanting to make the date_format uniform in the script)

=> Can you use the DATE([field], [format]) function to make the dates look the same on GUI level?

HTH

Best regards,

DataNibbler

[#3]

HI,

go to Documents Properties --> Number Tab and change the number - format accordingly.

HtH

Roland