Alpha DevCon Engineering Roundtables
Results 1 to 4 of 4

Thread: Convert Text to Short Date

  1. #1
    Member
    Real Name
    Fred Dove
    Join Date
    Jan 2008
    Posts
    348

    Default Convert Text to Short Date

    Hi guys, I need to convert a text field "short" date into a standard date field. (UK Format)
    Example 290117 converted to 29/01/2017

    Thanks

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,515

    Default Re: Convert Text to Short Date

    Try

    where txd is your "short date". In the mask() function there should be 2 spaces, forward slash, 2 spaces, forward slash, 20, 2 spaces.

    Code:
    ctod(mask(txd,"  /  /20  "))
    Last edited by Stan Mathews; 08-09-2017 at 02:43 PM.
    There can be only one.

  3. #3
    Member
    Real Name
    Fred Dove
    Join Date
    Jan 2008
    Posts
    348

    Default Re: Convert Text to Short Date

    Hi Stan, should this work in V10 ?
    Still getting invalid expression ?

  4. #4
    Member
    Real Name
    Fred Dove
    Join Date
    Jan 2008
    Posts
    348

    Default Re: Convert Text to Short Date

    I beg you pardon Stan. It works perfectly using a Calc field on my form.

    Many thanks for helping me. Top man.

    Fred

Similar Threads

  1. Convert ux date control value to sql date format
    By frankbicknell in forum Mobile & Browser Applications
    Replies: 15
    Last Post: 06-11-2015, 04:07 PM
  2. Duplicate record and keep short date format
    By J.R. Noe in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 01-29-2014, 05:01 PM
  3. Convert text to Proper
    By kliktap in forum Application Server Version 11 - Web/Browser Applications
    Replies: 7
    Last Post: 09-04-2013, 05:07 AM
  4. Using short Time date picker in 15 minute blocks
    By Hasher in forum Application Server Version 11 - Web/Browser Applications
    Replies: 1
    Last Post: 03-04-2013, 10:24 AM
  5. Short Date Format
    By Walter in forum Alpha Five Version 9 - Desktop Applications
    Replies: 3
    Last Post: 02-02-2010, 10:39 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
  •