Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlivers,
if I want to serarate date and time from a colume contained both date and time together. how do i do it??
thank you~~
This is a sample of the date colume.
none of the codes were actually not working,
but i actually figured out how to do it, Anyways guys, for future reference, here is what i have::
Date(date#(date(Floor(departure), 'DD/MM/YYYY'), 'MM/DD/YYYY'), 'MM/DD/YYYY') as OutputDate,
Timestamp(arrive-Floor(departure), 'hh:mm') as OutputTime;
Hi,
Give that there's no visual of teh Date & Time format from your data.
Try Date(Subfield(xxxx,1) as date
Time (Subfield(xxxx) as Time
It that didn't work then upload sample data.
Regards,
Gabriel
Hi Gabriel, here is what my date look like.
If your field is named MyField:
date(floor(MyField) as MyDate,
timestamp(MyField-floor(MyField) as MyTime,
Hi,
Try this code using LIST BOX
Right click anywhere in the sheet then New Sheet Object -> List Box -> Field pane select Expression -> then enter
=date(SubField(DateTime,' ',1)) click ok.
This will give you just the Date
Right click anywhere in the sheet then New Sheet Object -> List Box -> Field pane select Expression -> then enter
=time(SubField(DateTime,' ',2)) click ok.
This gives you the time part.
This works for me so it should work.
Regards,
Gabriel
Hi,
You Can create fileds like below
Date(Floor(DateTimeField)) As DateField
Time(Frac(DateTimeField)) AS TimeField
Hope it helps
Celambarasan