Function DatePart('q', Date()) work wrong for this year 2021

Andi Taufiq

• February 19, 2021 02:55

I have an issue about function DatePart() with quarter interval. When I put DatePart('q', Date()) to get current quarter of year it returned "2", the current date is 2021-02-18 so the correct quarter returned should be "1" not "2".

Does anyone else encounter this issue like me ?

Thanks

0

• 

  Blake

  • Logi Forum Guru
  • Logi Info Ninja
  • June 14, 2021 13:10

  I'm getting the correct results =DatePart('q', Date()) brings back 2 for today (June).  =DatePart('q', '2021-02-18') brings back 1.  Just to verify the obvious is your system clock correct on the machine you are executing this?

  0

Please sign in to leave a comment.