Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to find the way how to format data to date format so they will load as fast as possible.
I can see two ways:
The case is to speed up load / reload time to max. I don't consider design time right now. The goal is to format several fields to several format, so changing Document Settings is not a way.
Thanks for all comments,
Jindra
If you want maximum load performance and don't care about UI performance then don't format it in the script. I doubt you'll notice any difference in load time though. Best practise is to fix things as much as possible in the script so you have the cleanest data model (and data) and best performance in the UI.
If you want maximum load performance and don't care about UI performance then don't format it in the script. I doubt you'll notice any difference in load time though. Best practise is to fix things as much as possible in the script so you have the cleanest data model (and data) and best performance in the UI.
Do it in script as use of
date(date#(datefield,'DD/MM/YYYY'),'DD-MM-YYYY') as Date
here 1st format is your date field format and 2nd one is which format is you desired
hope it helps you
Thanks a lot for those quick replies.