• That worked. Thanks so

    That worked. Thanks so much !

    Originally Posted By [email protected]

  • viewpoint and date prompting

    newbie here. I'm trying to create a script w/several sequel views. I first want to prompt for a date (defined as a DATE type so the user gets the friendly little calendar). I then want to compare this &from date to transaction dates (8,0 yyyymmdd) to select/omit records.

    I'm having great difficulty getting this to work.

    Any examples/help would be greatly appreciated as I've struggled with this long enough now.

    Thanks in advance.

    Originally Posted By [email protected]

  • Script

    Hi there again!

    Please send me your script definition or at least a good screen shot of what you have so far. I can take a look at it and get back to you ASAP...

    Thanks,

    Jackie Daugherty

    Technical Consultant

    SEQUEL Software - A Help/Systems Company

    Phone: 952.933.0609

    Originally Posted By jdaugherty

  • You can send the definition

    You can send the definition to [email protected]

    Originally Posted By jdaugherty

  • Would you share the solution

    Would you share the solution for that problem please?

    Originally Posted By Zwicker KG

  • Date fields

    If you have a numeric field that you wish to display as a date value, you first need to covert the field with the CVTDATE function.  Your date example would convert with the following expression:  CVTDATE("01/09/12",dmy) or CVTDATE(yourdatefld,dmy).  To get an age of an invoice, you can use this expression:  DAYS(current date) - DAYS(CVTDATE(yourdatefld, type).  

    To pass a date value to a view as a variable, you need to defined the variable with quotes around it, i.e. "&&XYZ"  where &XYZ is a variable defined as a DATE type variable.  To calculate the age of the input value, you can create the following expression in the SELECT clause.  DAYS(current date) - Days("&&XYZ").

    Do not hesitate to contact Sequel support at 992-933-0609 if you have any additional questions on date conversions. 

    Originally Posted By richg

  • Thanks

    That worked perfect.

    Happy to have stayed with SEQUEL Viewpoint and Helpsystems. 

    Fyroze

     

    Originally Posted By Fyroze

  • Date Timestamp Conversion

    Ok, I use the following in an attempt to convert the Date Timestamp: CVTDATE(tiatim,MDY).

     

    This is the Date Timestamp: 20120925090000.

     

    The results came out as:  0001-01-01 for every record.

     

     

    Originally Posted By Liz Williams

  • Hi there Liz,   You could use

    Hi there Liz,

     

    You could use the TIMESTAMP function here. So it would be TIMESTAMP(yourdatefield, yourtimefield)

    Please give that a try and let us know,

    Thanks,
     

    Jackie Daugherty

    Technical Consultant

    SEQUEL Software - A Help/Systems Company

    Phone: 952.933.0609

    Fax: 847.273.1050

    Originally Posted By jdaugherty

  • Date Timestamp Conversion

    J,

     Thanks for your suggestion...

    This is the code I used and the results.

    CVTDATE(TIATIM/1000000,YMD1)

    The result is: 2012-09-26 which is ok but I'd like to try to out put it as 09/26/2012.

    Also, I'm now trying to convert and pull out the time portion of the field 20120926(172500)

    .. I have a lot to learn.

     

    Originally Posted By Liz Williams