LabVIEW Idea Exchange

cancel
Showing results for 
Search instead for 
Did you mean: 
Yamaeda

Date/Time format code

Status: New

Hi, it seems LV uses the 1st sunday/monday or the year as week 1, but ISO says the first 4+ day week is week 1. So i started searching for date/time codes on the web and found http://help.gnome.org/users/gthumb/unstable/gthumb-date-formats.html.en

 

(Since regexp is only partly documented in help i assumed the same was true here)

 

I found %V which was exactly what i needed, but it didn't work, neither in Format to string or Format date/time to string.

 

Thus my suggestion is to add/complement with the missing functions from the list:

%C

%D

%e

%E

%F

%g

%G

%h

%k

%l

%O

%P

%r

%R

%s

%T

 

regards

/Yamaeda

G# - Award winning reference based OOP for LV, for free! - Qestit VIPM GitHub

Qestit Systems
Certified-LabVIEW-Developer
4 Comments
GuenterMueller
Active Participant
I fully agree. One of my colleagues also had "your %V issue" and found a VI in the web named "Num__ro_semaine_ISO_SBZ.vi" which is doing this job. It would be a big benefit if LabVIEW would be capable in handling common format codes. To my opinion, "%V" is a common code. Side note: You have mentioned %V in your suggestion but it is missing in your list of missing format codes. This is by accident, isn't it?
Yamaeda
Proven Zealot
Thanks, yes %V was the reason this came up. 🙂
G# - Award winning reference based OOP for LV, for free! - Qestit VIPM GitHub

Qestit Systems
Certified-LabVIEW-Developer
PhillipBrooks
Active Participant

I created an ISO-8601 compliant date/time string VI a couple of years ago that I submitted to the Community forums. GerdW pointed out the same ISO week problem and pointed me to an example that I incorporated into my VI.

 

The best way would be for LabVIEW to support this.

 

https://decibel.ni.com/content/docs/DOC-7199

JB
Trusted Enthusiast
Trusted Enthusiast

The VI mentionned by GuenterMueller was written by one of our developpers on the base of this VI of rolfk. You will find it in this discussion.