How do i get the fist day of every month in objective scripting

Question

Question

Permo Jacobs · Jan 17, 2018

the start date must always
be the first day of the effective salary month.

Discussion (5)1

Log in or sign up to continue

Danny Wijnschenk · Jan 17, 2018

If you substract the current day-of-the month from the current date in $horolog format, you will end up with the first day of the current month in $horolog format :

Write $horolog - $zdate($horolog, 4) + 1

If your date is in another format, convert it using $zdateh/$zdate, see also :

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

and

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

2 0

Julius Kavay · Jul 20, 2021

Just a hint, I would take $ZD($h,2). For today, my development system (and systems at customers site) shows:

Write $horolog - $zdate($horolog, 4) + 1 --> 65925.93
Write $zdate($horolog,4) --> 20.07.2021
Write $horolog - $zdate($horolog, 2) + 1  --> 65926 // expected value

Later, this value (65925.93), as a $zdate() argument, gives you an <ILLEGAL VALUE>

For $zdate($horolog,4), the link you provided says:

4	DD/MM/[YY]YY (01/07/97 or 27/03/2002) — European numeric format. You must specify the correct dateseparator character (/ or .) for the current locale.

1 0

score 0 · Answer 1 · 2018-01-17T03:30:58-05:00

Eduard Lebedyuk · Jan 17, 2018

What do you mean?
If you have month and year just add 01 and produce the date.

0 0

score 0 · Answer 2 · 2021-07-20T09:40:16-04:00

Kalevi Nummelin · Jul 20, 2021

Looks a bit baffling at first, but what a beauty in that expression!

0 0

score 0 · Answer 3 · 2018-01-17T09:52:54-05:00

If you meant that you want to get the day (name/value) from the date then try $zdate(datevalue,dayformat) where datevalue is in $h format and dayformat is 10 for number of day in week, 11 for short day name, 12 for full day name.

check out the docs about $zdate , $zdateh, $systm.sql.datepart for more info about working with dates.