Posted Wed, 29 Aug 2012 17:56:00 GMT by Portal Admin

when using CVTDATE on a field with the value of 20501231 it outputs ????????//
If I convert 20120701 it returns 07/01/12 so I'm not sure what the issue is.
Thanks in advance for any date conversion/prompting help

Posted Thu, 16 Jun 2016 05:00:00 GMT by Portal Admin

Hi there,

If you go to File, Properties, and set your date format to *USA, those ?????? should go away. Please try and let me know!

Thanks,

Jackie Daugherty

Technical Consultant

SEQUEL Software - A Help/Systems Company

Phone: 952.933.0609

Fax: 847.273.1050

Originally Posted By jdaugherty

Posted Thu, 16 Jun 2016 05:00:00 GMT by Portal Admin
That worked. Thanks so much !

Originally Posted By [email protected]

Posted Thu, 16 Jun 2016 05:00:00 GMT by Portal Admin

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]

Posted Thu, 16 Jun 2016 05:00:00 GMT by Portal Admin

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

Posted Thu, 16 Jun 2016 05:00:00 GMT by Portal Admin
You can send the definition to [email protected]

Originally Posted By jdaugherty

Posted Thu, 16 Jun 2016 05:00:00 GMT by Portal Admin

Would you share the solution for that problem please?

Originally Posted By Zwicker KG

You must be signed in to post in this forum.