Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Monthstart(your_date_field)
Monthstart(your_date_field)
Load
Field1,
Field2,
....
YourDateField,
MonthStart(YourDateField) as FirstDateofMonth
From.. xxxx
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
Try this
Date(MonthStart([Fieldname],'DD/MM/YYYY')