S stanks Active Member Licensed User Longtime User Apr 28, 2015 #1 hi i have date/time as Code: Copy Mon, 13 Oct 2014 07:54:00 GMT this format is almost like Code: Copy "EEE, d MMM yyyy HH:mm:ss z" almost because with above format i get CEST and not GMT any1 have idea how to convert/parse this Code: Copy Mon, 13 Oct 2014 07:54:00 GMT to smth like Code: Copy 13.10.2014 that is format "dd.MM.yyyy" thanks
hi i have date/time as Code: Copy Mon, 13 Oct 2014 07:54:00 GMT this format is almost like Code: Copy "EEE, d MMM yyyy HH:mm:ss z" almost because with above format i get CEST and not GMT any1 have idea how to convert/parse this Code: Copy Mon, 13 Oct 2014 07:54:00 GMT to smth like Code: Copy 13.10.2014 that is format "dd.MM.yyyy" thanks
thedesolatesoul Expert Licensed User Longtime User Apr 28, 2015 #2 What exactly are you doing (in code)? I would expect something like: Code: Copy DateTime.DateFormat = "EEE, d MMM yyyy HH:mm:ss z" Dim myDate as Long = DateTime.DateParse("Mon, 13 Oct 201407:54:00 GMT") DateTime.DateFormat = "dd.MM.yyyy" Log(DateTime.Date(myDate)) Upvote 0
What exactly are you doing (in code)? I would expect something like: Code: Copy DateTime.DateFormat = "EEE, d MMM yyyy HH:mm:ss z" Dim myDate as Long = DateTime.DateParse("Mon, 13 Oct 201407:54:00 GMT") DateTime.DateFormat = "dd.MM.yyyy" Log(DateTime.Date(myDate))
S stanks Active Member Licensed User Longtime User Apr 28, 2015 #3 already tried that but i get err unparsable date. this depends on locale or not? Upvote 0
S stanks Active Member Licensed User Longtime User Apr 28, 2015 #4 now i see that the problem is locale....my device is not eng locale thanks thedesolatesoul Upvote 0