Converting Pick Date To Mm/dd/yy

Legacy Poster

• April 10, 2014 22:01

I have a .DAT file that is downloaded from a U2 Database that contains a PICK Date of 16902 (16,902 days have passed since 12/31/1967)  I am trying to convert that 16902 to 04/10/14 and I am not having any luck.  I am using Bartender 10.1 .

Any suggestions on how to do this?

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • April 11, 2014 15:03

  Create a text object and in the data source under the "Type" tab choose the date option.  Switch back to the "Data Source" tab and set the value to be 31st December 1967.  Now select the ""Transforms" tab, and for the "Offset" properties choose the offset to come from a database field, selecting the "pick date" field in the number of days.  This should result in what you want.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • April 11, 2014 15:59

  Ian,

  I appreciate your response.  This was so much more simple than the script I was attempting to use.  Many, many thanks!

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • May 23, 2016 07:14

  Any help about the BigInt datatype from SQL then convert to Date format like "yyyy-mm-dd".

   

  1441641600000 to "yyyy-mm-dd".

   

  Appreciate any help.

  0
• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • May 23, 2016 07:48

  I would say you'd probably need to use VB script to do the conversion there.

  0

Please sign in to leave a comment.