What is the script to display 1st day of month?

[#1]

Hi, I have a date field and I want to create another field which only has the 1st day of each month in it. How do I script it? Thanks.

[Colin-Albert · Accepted solution]

Monthstart(your_date_field)

[MK_QSL]

Load

     Field1,

     Field2,

     ....

     YourDateField,

     MonthStart(YourDateField) as FirstDateofMonth

From.. xxxx

[Anonymous]

Many ways are there:

>> monthstart

>> makedate(year(your_date_field),month(your_date_field),1)

>> date(MakeDate(your_date_field)-day(your_date_field)+1)

etc...

Best is to use QV function MONTHSTART

[Anonymous]

Try this

Date(MonthStart([Fieldname],'DD/MM/YYYY')