Hello, the noob is back
I'we been trying to set up a date and time field from this:
200710311004
text field
to
2007-10-31T10:04:00Z
Date & Time with the following format
{CCYY-MM-DD}T{HH24:MM:SS[.0-6][+/-ZZ:ZZ]}
I really cant get this to work, its the Z that is my nemesis.
First i just changed the field to text, and use subtract, but now that i need it for different timezones, i need to have it in Date & Time subclass.
Can anyone help me solve this riddle?
Problem with Date & Time
..
So wait...you're trying to get the time zone out of an input field, that doesn't have the time zone in it? You may get a date in this input field that is a few days old, and you want to include the "ZZ:ZZ? Or is it always the current date, like, whatever date is in that field, plus the current ZZ:ZZ?
I've personaly never had a need to use the ZZ:ZZ, but I was thinking something like:
=FROMDATETIME(TODATETIME("200710311004"),"{CCYY-MM-DD}T{HH24:MM:SS[.0-6][+/-ZZZZ]}")
But I could get that to work.
good luck.
I've personaly never had a need to use the ZZ:ZZ, but I was thinking something like:
=FROMDATETIME(TODATETIME("200710311004"),"{CCYY-MM-DD}T{HH24:MM:SS[.0-6][+/-ZZZZ]}")
But I could get that to work.
good luck.
..
So wait...you're trying to get the time zone out of an input field, that doesn't have the time zone in it? You may get a date in this input field that is a few days old, and you want to include the "ZZ:ZZ? Or is it always the current date, like, whatever date is in that field, plus the current ZZ:ZZ?
I've personaly never had a need to use the ZZ:ZZ, but I was thinking something like:
=FROMDATETIME(TODATETIME("200710311004"),"{CCYY-MM-DD}T{HH24:MM:SS[.0-6][+/-ZZZZ]}")
But I could get that to work.
good luck.
I've personaly never had a need to use the ZZ:ZZ, but I was thinking something like:
=FROMDATETIME(TODATETIME("200710311004"),"{CCYY-MM-DD}T{HH24:MM:SS[.0-6][+/-ZZZZ]}")
But I could get that to work.
good luck.
Hi.
Well, I did a workaround, with a submap, and changed the datetime to text..
Well, I did a workaround, with a submap, and changed the datetime to text..
Code: Select all
=left((text(addhours(todatetime(DateTime,"{CCYYMMDDHH24MM}"), 1))),4)+ "-"
+
mid((text(addhours(todatetime(DateTime,"{CCYYMMDDHH24MM}"), 1))),5,2)+ "-"
+
mid((text(addhours(todatetime(DateTime,"{CCYYMMDDHH24MM}"), 1))),7,2)+ "T"
+
mid((text(addhours(todatetime(DateTime,"{CCYYMMDDHH24MM}"), 1))),9,2)+ ":"
+
mid((text(addhours(todatetime(DateTime,"{CCYYMMDDHH24MM}"), 1))),11,2)+ ":00" + "Z"