Converting Pick Date To Mm/dd/yy

Legacy Poster

• 2014年04月10日 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

  モデレータ

  ★ BarTender Hero ★

  • 2014年04月11日 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 ★

  • 2014年04月11日 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 ★

  • 2016年05月23日 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

  モデレータ

  ★ BarTender Hero ★

  • 2016年05月23日 07:48

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

  0

サインインしてコメントを残してください。