Alpha Video Training
Results 1 to 4 of 4

Thread: Date Calculatiions

  1. #1
    Member
    Real Name
    william gleason
    Join Date
    Mar 2014
    Location
    Littleton, CO
    Posts
    2

    Default Date Calculatiions

    I am attempting to write a function to calculate the duration Dur (N) between 2 dates (D). Dur = {end_date} - {start_date}. It all seems to be pretty simple and works as a calculated field in the desktop version. For some reason I can't get it to run in the Webapp. I get N.... gibberish instead of a number. Obviously doing something wrong... Any suggestions.

    Will

  2. #2
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,405

    Default Re: Date Calculatiions

    Post your code.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  3. #3
    Member
    Real Name
    william gleason
    Join Date
    Mar 2014
    Location
    Littleton, CO
    Posts
    2

    Default Re: Date Calculatiions

    Quote Originally Posted by gleason.will View Post
    I am attempting to write a function to calculate the duration Dur (N) between 2 dates (D). Dur = {end_date} - {start_date}. It all seems to be pretty simple and works as a calculated field in the desktop version. For some reason I can't get it to run in the Webapp. I get N.... gibberish instead of a number. Obviously doing something wrong... Any suggestions.

    Will
    DIM Dur as N
    DIM finish_date as D
    DIM start_date as D
    finish_Date = {06/01/2014}
    start_date = {06/15/2014}
    dur = finish_date - start_date

  4. #4
    "Certified" Alphaholic
    Real Name
    Govindan Gandhi
    Join Date
    Aug 2008
    Location
    New York, NY
    Posts
    4,294

    Default Re: Date Calculatiions

    I get N.... gibberish
    if you get NaN then it is a javascript function you are writing and the javascript does not know what to do.
    but what you are writing is xbasic.
    so where is the code placed?
    in a grid or a dialog?
    what makes the code run?
    these decide how this is implemented.
    then you can write the code in that area using xbasic and get that done.
    thanks for reading

    gandhi

    version 11 3381 - 4096
    mysql backend
    http://www.alphawebprogramming.blogspot.com
    ggandhi344@gmail.com
    Skype:ggandhi344@gmail.com
    1 914 924 5171

Similar Threads

  1. UX - repeating section not saving date values -??? date format issue?
    By RIckyRel in forum Mobile & Browser Applications
    Replies: 4
    Last Post: 11-12-2013, 03:58 PM
  2. MySQL current date minus date field issue
    By George Corder in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 03-21-2013, 09:39 PM
  3. Import Genie Error 1292 - 'Incorrect date value: '10/17/2011' for column 'Date'
    By betty in forum Application Server Version 11 - Web/Browser Applications
    Replies: 0
    Last Post: 12-27-2011, 12:35 AM
  4. Date Range Fields in Search doesnt respect Grid Properties Date Format or Textbox For
    By aburningflame in forum Application Server Version 10 - Web/Browser Applications
    Replies: 2
    Last Post: 04-25-2011, 01:38 PM
  5. Replies: 0
    Last Post: 06-22-2006, 05:17 AM

Bookmarks

Posting Permissions

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