Date Conversion Question Lotus Script / Fromulas @TextToTime Internationally
Daniel Nashed – 25 June 2019 04:29:49
I ran into an issue with my delete log application when converting timedates from the internal format like [20190612T154744,66-05] to a date when the server is in the US. What I have assumed is that if I specify a dot instead of the slash the @TextToTime function would work with day.month.year.
But it appears it is still working month.day.year instead.
Does anyone have an idea how to do this conversion operation safely internationally?
Is there any save string format which will always corrected in the same way?
In C-API it would be simple. You can fill in the corresponding values in the TIME structure and convert.
But I did not find anything like that in @Formulas or LotusScript.
Before I start spending time on it, probably someone has solved this already ...
-- Daniel
- Comments [8]
![[HCL Domino]](../lotus-domino.gif){kind=small}
![[Domino on Linux]](../domino-linux.gif){kind=small}
![[Nash!Com]](../nashcom.gif){kind=small}
![[Daniel Nashed]](../daniel-nsh.gif){kind=small}