Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
this field consists of date + time (see figure). I would like to make 2 colommun here. 1 with only the date and 1 with only time. Someone any idea how I can do this.
Hi,
If the above doesn't work you can try.
Date(SUBFIELD(ScanDatumTijd,' ',1),10),'DD-MM-YYYY')
Timestamp(SUBFIELD(ScanDatumTijd,' ',2),'hh:mm:ss')
Mark
For Date : Date(FieldName,'DD-MM-YYYY')
For Time: Timestamp(FieldName,hh:mm:ss)
Hi,
If the above doesn't work you can try.
Date(SUBFIELD(ScanDatumTijd,' ',1),10),'DD-MM-YYYY')
Timestamp(SUBFIELD(ScanDatumTijd,' ',2),'hh:mm:ss')
Mark
Thankyou both it did work out! i have one other question:
i want to count al the deliveries (the timestamps are times of deliverie) that are arrived after 10:00:00. Any idea how to do that?
Thanks in advance!!