Date Formatting Problem

This topic has 5 replies, 4 voices, and was last updated 15 years, 10 months ago by Gary Atkinson.

Creator

Topic
October 3, 2008 at 8:13 am #50344

David Harrison
Participant

In an Xlate, I want to convert a date where the day and month have no leading zero. As an example, today is presented as 3/10/2008.

I would like to know the best way to convert this to the format CCYYMMDD.

Thanks,

Dave
Creator

Topic

Viewing 4 reply threads

Author

Replies
- October 3, 2008 at 12:29 pm #65699
  
  Charlie Bursell
  Participant
  
  set dt 3/10/2008
  
  set newdt [clock format [clock scan $dt] -format %Y%m%d]
  
  => 20080310
- October 3, 2008 at 1:17 pm #65700
  
  David Harrison
  Participant
  
  That simple! Many thanks.
- November 24, 2008 at 1:45 pm #65701
  
  Gary Atkinson
  Participant
  
  If I had date that also included the time, how would I use clock to just return the date? For example my date/time value is: 20080921194800 and I want to return only 09/21/2008.
- November 24, 2008 at 2:24 pm #65702
  
  Rob Abbott
  Keymaster
  
  read up on “clock scan” in tclhelp. It accepts several formats.
  
  In this case you would only want to send teh first 8 digits of your timestamp to clock scan in the code above:
  
  set dt [string range $datetime 0 7]
  
  set newdt [clock format [clock scan $dt] -format %Y%m%d]
  
  Rob Abbott
  Cloverleaf Emeritus
- November 24, 2008 at 3:38 pm #65703
  
  Gary Atkinson
  Participant
  
  Thanks Rob.
Author

Replies

Viewing 4 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.