nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

The Doctor Cures  Your Date and Time Import Problems

stan_koprowski

Comments

Ake

Why did I not come across this before? I needed this so many times! Many thanks!

Ake

hogi

Thanks @brady_brady for this wonderful talk on how to fight with data formats.

How about

(from the video)

or 15b (with points) :

looks very dangerous - hard to detect the inconsistency/issue !

brady_brady

@hogi

Both of those examples are delimited, so you can fill out the dialog as below. The second example has slash delimiters rather than dots, but it will otherwise be the same.

hogi

Thanks

Another way to get March 04:

Informat( "4.3.2023", "Format Pattern", "<DD></><MM></><YYYY>" );
Informat( "4/3/2023", "Format Pattern", "<DD></><MM></><YYYY>" );

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of