Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a field in which date is given in the no. format as 19790601
plz help me to find out how to get the date,month,year from this no.
first you have QV to tell the format: Date#(YourNoField, 'YYYYDDMM') as example.
Now you are able to build Year, ad so on:
Load *,
Year(YourDateFormat) as Year,
Day(YourDateFormat) as Day;
Load
Date(Date#(YourNoField, 'YYYYDDMM') , 'DD-MM-YYYY') as YourDateFormat,
Field2
From .......
Hope it helps.
Rainer