changing date in qv

thanhphongle — Wed, 10 Jun 2015 13:57:28 GMT

Hello Community,

i have a database with different dates:

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

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

Re: changing date in qv

swuehl — Wed, 10 Jun 2015 14:16:00 GMT

Look into Monthstart() QV date function:

LOAD Date,

DayName(Monthstart(Date)) as NewDate,

...

FROM ...;