+ Reply to Thread
Results 1 to 4 of 4

Thread: Validate ISO date in /Free?

  1. #1
    Guest.Visitor Guest

    Default Validate ISO date in /Free?

    The test opcode is supported in /free Test(de) *mdy Testdate; If %error; ...

  2. #2
    Guest.Visitor Guest

    Default Validate ISO date in /Free?

    The date format you posted is *USA, not *MDY. Do this: Monitor; wtDate = %DATE(TDATE:*USA); On-Error; // do something - invalid *USA date EndMon; Chris

  3. Default Validate ISO date in /Free?

    I am trying to validate the date before converting into ISO format. The code I am using to put into ISO is below: wtDate = %DATE(TDATE:*MDY); Where wtDate is my ISO date field inz in the D specs, Tdate is my incoming date. Let's say Tdate = 11032003. This works just fine. Converts the date to -2003-11-03' However lets say the incoming date is 11332003. Ofcourse once this piece of code is ran I will get a date timestamp error. The old method I used was: C *mdy Test(D) Testdate where testdate would be the 6 digit version of the date. And if %found it would then proceed to error out to an report and default date to '0001-01-01' Thanks for any suggestions if this is possible in /free

  4. Default Validate ISO date in /Free?

    Thanks, that works

+ Reply to Thread

Similar Threads

  1. Replies: 8
    Last Post: 04-25-2007, 07:18 AM
  2. Convert Numeric to Date() in /Free
    By Guest.Visitor in forum General
    Replies: 2
    Last Post: 09-17-2004, 06:19 AM
  3. /free date manipulation
    By rawinans in forum RPG
    Replies: 1
    Last Post: 07-20-2004, 10:28 AM
  4. Replies: 7
    Last Post: 02-11-2004, 04:40 AM
  5. Converting Date in /Free
    By Guest.Visitor in forum RPG
    Replies: 5
    Last Post: 10-17-2003, 08:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts