changing date in qv

[thanhphongle]

Hello Community,

i have a database with different dates:

Date
14.06.2001
22.08.2003
30.04.2005
09.05.2006

my question is, how can i change all dates to the 1st of a month. see below:

New Date
01.06.2001
01.08.2003
01.04.2005
01.05.2006

maybe with a if function. but i dont really know how to write it in qv

if(date(DD>1,MM,YYYY), then date(DD=1,MM,YYYY) something like this

[swuehl · Accepted solution]

Look into Monthstart() QV date function:

LOAD Date,

          DayName(Monthstart(Date)) as NewDate,

     ...

FROM ...;