Re: Texttodate, yyyymmdd -> mm/dd/yyyy

Yes, sorry.

"Adam Price" <Adam-price@xxxxxxx> wrote in message
news:pXN5f.121$uo3.40133@xxxxxxxxxxxxxxxxxxxxxxx
> In article <5JmdnXW0zqjsPsreRVn-sg@xxxxxxxxxxx>, Bill Marriott wrote:
>> And you can avoid the need for an additional field by using the Replace
>> command. Start out with date_old as a text field. Specify a calculated
>> result in the replace. Then change date_old to a date field.
>>
>> Bill
>
> How do I access that? I tried using replace as part of a calculation,
> but it fails with a circularity error.
>
> Replace( Date_sold,0,8, Date( Middle(Date_sold, 5, 2),
> Middle(Date_sold, 7, 2),
> Left(Date_sold, 4)
> ))
>
>
> Understandable.
>
> I would think that there would be some sort of replace command in the
> edit menu, but there is only find/replace, which seems to deal with
> literals, not the command set. Is this new functionality since FM6.0?


.

Relevant Pages

  • Re: Callback function is not executed while Matlab is busy
    ... I have the problem that Matlab doesn't execute the callback-function ... I wrote an m-function which performs some longer calculation. ... If I force the calculation to pause using this command ... and if I click on the button duringthis pause it works. ...
    (comp.soft-sys.matlab)
  • Re: "Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O)
    ... > I think Escape has always worked for me to interrupt the calculation. ... > typing anything into a cell also tells excel to stop calculating and wait ... >> Is there a way to intercept the Grouping command by some code? ... >>> Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: GLHTT
    ... Sorry, Lady Sanity, I try to avoid taking them on command. ... Dirk Vdm ... Prev by Date: ...
    (sci.physics.relativity)
  • Re: Command execution sequence in VBA
    ... I am using a small macro (VBA) in my ms project file doing various things. ... But while executing this macro the command Application.CalculateAll ... Project does its calculation last although the code will ...
    (microsoft.public.project.vba)
  • Re: Two calculations in a field
    ... Thank you Vandar and Harry. ... The command doesn't have to have the lines formatted this way, ... The 'results' can also be any form of Calculation that returns to ... 20% tax for RegionCode "C" or add no tax for any other RegionCode. ...
    (comp.databases.filemaker)
Loading