GSA Pro 5.3. Converting Date YYYYMMDD format

[Björn Schaefer]

Hi all

I'd like to convert a given date into another format:

What I've tried so far:



as you can see, this won't work properly, 'cause the result should be 20220311 instead of 2022311 (see marked row above)

trying it this way, the result isn't working at all:


any hints / ideas?

thanks a lot so far !

 

[Frank Pistorius]

Hi Björn,

Have you tried formatting the date itself directly, using:

[Arz Datum].ToString("yyyyMMdd")

That should hopefully result in a string with the correct format.

Regards,

Frank

 

[Björn Schaefer]

Hi Björn,

Have you tried formatting the date itself directly, using:



That should hopefully result in a string with the correct format.

Regards,

Frank

yes I did that, but unfortunately with YYYY instead of yyyy...

checking out this, everything is fine:


so let me say: THANK YOU

 

[Frank Pistorius]

Hi Björn,

Good to hear you've got things up and running.

For future reference, the DateTime.ToString() method page in the GSA Documentation shows some more possibilities with respect to formatting strings.

Regards,

Frank