Converting Pick Date To Mm/dd/yy 追蹤

0
Avatar
Legacy Poster

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?

4 意見

0
Avatar
Ian Cummings
版主
評論操作 永久連結

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
Avatar
Legacy Poster
評論操作 永久連結

Ian,

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

0
Avatar
Legacy Poster
評論操作 永久連結

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
Avatar
Ian Cummings
版主
評論操作 永久連結

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

登入寫評論。