• Replies 1 reply
  • Subscribers 415 subscribers
  • Views 22 views
  • Users 0 members are here
Related

date AND time on a list

Eva Høj Andersen
$organization

Hi all

Please help me figuring this out. We are hosting a night of fun and on this night we want to have 16 competions, which is: sign up for our newsletter and we will draw a winner for each competition which is every 20 minutes. So usually I just create a list of customers with a competition interest and a date criteria and then run the New record summary report to get a list of all new customers who have signed up. So in this new case I need to be able to see a specifik time of day also to make sure I can see when they have signed up. And I do not want to create 16 different interests, does anyone know how I can get the specifik create date AND time on a constituent Interest ?

Hope I make sense. 

Thanks 

Eva 

Parents
  • $organization

    > does anyone know how I can get the specifik create date AND time on a constituent Interest ?

    You could make a custom view, querying TX_CUST_TKW and extracting the hours and minutes from the create_dt column, e.g.:

    select top 20 customer_no
    ,create_dt
    ,datepart(hh,create_dt) as create_dt_hour
    ,datepart(MI,create_dt) as create_dt_minute
    from TX_CUST_TKW 
    where tkw = 93 
    and selected = 'Y'

    ...which List elements could then be created from. Make sense?

    Greetings from a Danish Minnesotan :-)

Reply
  • $organization

    > does anyone know how I can get the specifik create date AND time on a constituent Interest ?

    You could make a custom view, querying TX_CUST_TKW and extracting the hours and minutes from the create_dt column, e.g.:

    select top 20 customer_no
    ,create_dt
    ,datepart(hh,create_dt) as create_dt_hour
    ,datepart(MI,create_dt) as create_dt_minute
    from TX_CUST_TKW 
    where tkw = 93 
    and selected = 'Y'

    ...which List elements could then be created from. Make sense?

    Greetings from a Danish Minnesotan :-)

Children
No Data