Forum

Unknown delimiter for StrSplit

eyup yilmaz

Dec 21, 2018 10:03 PM

Active user

Points:: 0
Joined:: Mar 6, 2018

Hello!

I have a problem with date to string coversion;

Code
y = year(CurrentDate); z = String(y);

"z" can be "2,018" or "2 018" or "2.018" according to regional settings...

Every client have different settings, is there any way to solve this?

Profile

eyup yilmaz

Dec 21, 2018 10:10 PM

Active user

Points:: 0
Joined:: Mar 6, 2018

I found this way;

Code
ch = Left(Right(z,4),1);

with this way i can get 2nd character what ever its.

Profile

Sergey Blagoveshchenskiy	#3 Dec 22, 2018 02:15 PM
Just came Points:: 0 Joined:: Jun 10, 2016	Try to use this: y = year(CurrentDate); z = Format(y, "NG=");
	Profile

Vladimir Gurov	#4 Dec 25, 2018 04:36 AM
Interested Points:: 0 Joined:: Dec 4, 2017	Dear eyup yilmaz, Sergey provided an appropriate example for you as using the Format() function is a correct way to get date and time in the format you need. Best regards, Vladimir Gurov
	Profile

Users browsing this topic (guests: 1, registered: 0, hidden: 0)