Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi;
in my list of birthday fields looks like ( 01/01/1980 12:00:00 AM ) but i just want to see ( 01/01/1980 ) because i have to use this format.
i use purgechar and trim in edit script before reload but it does not work. some points i did not catch ?
Thanks in advence
It looks like this is a TIMESTAMP field and not a string, so try Date(YourDateFieldName,'DD/MM/YYYY') instead of purge/trim.
Hi,
try this in your script .it should work.
load left(01/01/1980 12:00:00 AM,index(01/01/1980 12:00:00 AM,' ')) as column;
thanks
Hi;
Thanks for responses...
I try both scripts but it does not work immediately. Default field in the database is BIRTH_DATE and format looks like "01/01/1980 12:00:00 AM" I'd like DD/MM/YYYY(e.g. 01/01/1980) and i dont want to see timestamp. Those scripts give me numbers with unknown format (e.g. 0040-01-01)
I am so confused about this problem...
I am just waiting your ideas.
Thanks
If its just a display issue you should load the field as normal, and then set the display number format to use "Date", this can be done in document properties, number tab, or the number tab of the object displaying the field.
Thank you...
It works troubleless