Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Strange Dateformat Question

Strange Dateformat Question 3 months 3 days ago #19755

  • downing
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 32
  • Thank you received: 1
Hi Together,
Do you now a solution to format the Minute Field to Format:
20-02-2020 00:12 --> 20-02-2020 00:00
20-02-2020 00:44 --> 20-02-2020 00:30
< 30 Minutes should be 00
>= 30 MInutes should be 30

thx
downing

...

Please Log in or Create an account to join the conversation.

Strange Dateformat Question 3 months 3 days ago #19758

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7796
  • Karma: 33
  • Thank you received: 465
There are multiple ways of doing it for example

You can get the last two characters using the right function and compare them with 30 like this:



Mike
Attachments:

Please Log in or Create an account to join the conversation.

Strange Dateformat Question 2 months 4 weeks ago #19759

  • downing
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 32
  • Thank you received: 1
thx :)

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 118 guests and one member online